VALUES Clause

noun

say it: “VAL-yooz klawz” /ˈvæljuːz klɔːz/

The part of an INSERT that lists the values for the new row, in parentheses.

What does VALUES Clause do in a relational database?

VALUES Clause — A clause that supplies rows of literal or calculated values.

INSERT INTO customer (customer_id, email)
VALUES (1, 'ada@example.com');

In a sentence

  • “The VALUES clause gave the new shipper's name and phone.”

Level: Apprentice · More SQL terms at this level

Updated