Updating Data in a Table

To UPDATE data in an existing table, use the standard SQL UPDATE syntax:

UPDATE myTable SET columnTwo = 'column2Value', columnThree = 'column3Value'
WHERE columnOne = 'col1Value'



If it is necessary to UPDATE a table with a NULL value you can do this by specifying the column value as ''. (two single quotes with no space inbetween)