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,
column2 = value2,
WHERE column3 = value3;
xxxxxxxxxx
UPDATE table
SET column1 = value1,
column2 = value2 ,
WHERE
condition;
xxxxxxxxxx
UPDATE schema.table_name
SET column1 = 'value1'
, column2 = 'value2'
,
WHERE column3 = 'criteria'