Update command syntax

Wednesday, 12 March 2008 18:33

Update syntax introduction:

    Update command alters the data contained in the table. It can change multiple columns at once and use multiple conditions. 

update tablename set col1=2, col2='string' where col0=0

This will effectively update the two mentioned columns in the row that matches the condition after the where modifier.