Utilizor

MySQL Update

Updating records.

MySQL UPDATE Statement

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

Be careful when updating records! If you omit the WHERE clause, ALL records in the table will be updated!

Example

UPDATE Customers SET ContactName='Alfred Schmidt', City='Frankfurt' WHERE CustomerID=1;