SET Clause

noun

say it: “SET klawz” /sɛt klɔːz/

The part of an UPDATE that says which columns get which new values.

What does SET Clause do in a relational database?

SET Clause — The UPDATE clause assigning new values to columns.

UPDATE customer
SET status = 'inactive'
WHERE customer_id = 1;

In a sentence

  • “The SET clause gave Chai its new price.”

Level: Apprentice · More SQL terms at this level

Updated