The following SQL statement defines the "Personid" column to be an auto-increment primary key field in the "Persons" table:
Personid int NOT NULL AUTO_INCREMENT,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
PRIMARY KEY (Personid)
);
MySQL uses the AUTO_INCREMENT
keyword to perform an auto-increment feature.
By default, the starting value for AUTO_INCREMENT
is 1, and it will increment by 1 for each new record.
To let the AUTO_INCREMENT
sequence start with another value, use the following SQL statement:
To insert a new record into the "Persons" table, we will NOT have to specify a value for the "Personid" column (a unique value will be added automatically):
VALUES ('Lars','Monsen');
The SQL statement above would insert a new record into the "Persons" table. The "Personid" column would be assigned a unique value. The "FirstName" column would be set to "Lars" and the "LastName" column would be set to "Monsen".
Practice Excercise Practice now