Python Programming : A Modern Approach

Databases 13.5

Here, table_name is the table in which to update a record (or records). The table_name

is followed by the keyword SET and a comma-separated list of eld name/value pairs

in the format eld_name = value. The WHERE clause species the criteria which is

used to determine which record(s) is to be updated.

Be careful when updating records in a table! Notice the WHERE clause in the UPDATE state-

ment. The WHERE clause species which record(s) that should be updated. If you omit the

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

NOTE

UPDATE movies SET rating=8.7 WHERE movie='Frozen';

The above syntax updates a record in the ‘Movies’ ...