mySQL primary key auto increment code example
Example 1: mysql alter column auto increment
ALTER TABLE document MODIFY COLUMN document_id INT auto_increment
Example 2: how to auto increment in sql
CREATE TABLE Persons (
Personid int NOT NULL AUTO_INCREMENT,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
PRIMARY KEY (Personid)
);
INSERT INTO Persons (FirstName,LastName)
VALUES ('Lars','Monsen');
Example 3: mysql set id auto increment
ALTER TABLE users AUTO_INCREMENT=1001;
Example 4: create a table with an id in mysql
CREATE TABLE DemoT (
Personid int NOT NULL AUTO_INCREMENT,
LastName varchar(111) NOT NULL,
FirstName varchar(111),
Age int,
PRIMARY KEY (Personid)
);
Example 5: auto_increment mysql
ALTER TABLE User AUTO_INCREMENT = 1;
Example 6: create table primary key auto increment mysql
define primary key auto increment