Which of the below is the correct query to update the columns of a table:
update table TABLE_NAME set COMLUMN_NAME= where
update TABLE_NAME set COMLUMN_NAME= where
Both 1 & 2 are correct
None of the above