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)

 
 

DBLX SQL Guide