MyJgui logoCross-platform graphical MySql client/front-end

Update command syntax

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.