Lesson 6: Designing Data Rows

Question 1

INSERT INTO… VALUES

Answer 1

A SQL statement used to insert data rows in a database table

Question 2

Column list

Answer 2

The list of columns that are in the table structure. These are the table columns that will be added in the INSERT INTO SQL statement.

Question 3

Value list

Answer 3

The data values that will be added to the table columns in the INSERT INTO SQL statement

Question 4

Duplicate key

Answer 4

A key value that is being added to the database table that violates the PRIMARY KEY constraint.