xxxxxxxxxx
UPDATE schema.table_name
SET column1 = 'value1'
, column2 = 'value2'
,
WHERE column3 = 'criteria'
xxxxxxxxxx
UPDATE courses
SET published_date = '2020-08-01'
WHERE course_id = 3;
Code language: SQL (Structured Query Language) (sql)
xxxxxxxxxx
UPDATE table_name
SET column1 = value1, -- without quotes for numeric values
column2 = 'value2', -- with single quotes for text values
WHERE condition;