Learn SQL Database Programming

Syntax for updating data

To UPDATE certain data in a table, you can use the following sample syntax:

UPDATE tablename SET col1 = 'value1', col2 = value2WHERE col1 = 'value3';

To UPDATE all the data in a table, you can use the following sample syntax:

UPDATE tablename SET col1 = 'value1'; 

To UPDATE data in a table based on a query, you can use the following sample syntax:

UPDATE tablename tnINNER JOIN anothertablename atn ON tn.col1 = atn.col1 SET tn.col2 = atn.col2;