Lesson 6: Designing Data Rows Flashcards
1
Q
INSERT INTO… VALUES
A
A SQL statement used to insert data rows in a database table
2
Q
Column list
A
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.
3
Q
Value list
A
The data values that will be added to the table columns in the INSERT INTO SQL statement
4
Q
Duplicate key
A
A key value that is being added to the database table that violates the PRIMARY KEY constraint.