INSERT

noun

say it: “in-SERT” /ɪnˈsɜːrt/

The SQL statement that adds new rows to a table.

What does INSERT do in a relational database?

INSERT — A statement that adds new rows to a table.

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

In a sentence

  • “An INSERT added the new shipper to the Shippers table.”

Level: Apprentice · More SQL terms at this level

Updated