SQL: AUTO INCREMENT flash cards

Set: SQL: AUTO INCREMENT

Familiarize		Learn		Test
Play Scatter			Play Space Race

Term	Definition
CREATE TABLE table_name (column_name1 PRIMARY KEY AUTOINCREMENT,column_name2 NOT NULL,)	to define an auto-increment primary key
CREATE TABLE table_name (column_name1 PRIMARY KEY AUTOINCREMENT (intial value, increment),column_name2 NOT NULL,)	to define an auto-increment primary key with different initial value than 1 and increment greater than 1
INSERT INTO Persons (column_name1, column_name2)VALUES ('value1','value2')	to insert a new record into a table with auto-increment

No Messages

Report as inappropriate