#mysql sql query

MySQL UPDATE Statement

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

UPDATE Syntax:

UPDATE table_name SET column1 = value1, column2 = value2, … WHERE condition;

Be careful when updating records in a table! Notice the WHERE clause in the UPDATE statement. The WHERE clause specifies which record(s) that should be updated. If you omit the WHERE clause, all records in the…