Updating database tables

In this case, the comment describes a permissible variation of the syntax.

If you omit the WHERE clause, all records in the table will be updated!

In turn, those design principles affect how you enter data.

Remember these facts about database objects and design as you proceed.

After the tables have been created and the data added, changing or updating data in the tables becomes one of the day-to-day processes in maintaining a database.

Doctrine's sole goal is to give you powerful tools to make database interactions easy and flexible.

The SQL UPDATE Query is used to modify the existing records in a table.

You can use the WHERE clause with the UPDATE query to update the selected rows, otherwise all the rows would be affected.

To obtain a new instance of the JDatabase Query class we use the JDatabase Driver get Query method: takes an optional argument, $new, which can be true or false (the default being false).

To query our data source we can call a number of JDatabase Query methods; these methods encapsulate the data source's query language (in most cases SQL), hiding query-specific syntax from the developer and increasing the portability of the developer's source code.

Leave a Reply