Loading lesson path
Concept visual
Start at both ends
statement is used to update or modify one or more records in a table.
table_name
column1 = value1, column2 = value2, ...
condition
;Be careful when updating records in a table! Notice the WHERE
clause in the UPDATEstatement.
clause specifies which record(s) that should be updated. If you omit the WHERE clause, all records in the table will be updated!
Customers table used in the examples:
Obere Str. 57
12209
Avda. de la Constitución 2222 México D.F. 05021
Antonio Moreno TaquerÃa