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');

Sql query to make a existing column auto increment

Alter table table_name modify column_name datatype(length) AUTO_INCREMENT PRIMARY KEY

Source: stackoverflow.com

Similar codes

0 vote288 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote266 views1 answer
Char varchar nvarchar sql
SQL
2 votes278 views1 answer
Sql server check for value in multiple columns
SQL
0 vote290 views1 answer
Oracle select partition
SQL
0 vote259 views1 answer
How to get n result in sql
SQL
9 votes272 views3 answers
Oracle undo usage by session
SQL
1 vote277 views2 answers
Change table name phpmyadmin
SQL
7 votes280 views6 answers
Group_concat mysql
SQL
0 vote278 views5 answers
Sql table intermédiaire
SQL
0 vote267 views1 answer
Date diff sql
SQL