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 vote167 views1 answer
Datatables server side filter where clause
SQL
5 votes151 views2 answers
Update all rows mysql
SQL
1 vote165 views1 answer
Postgresql how to show table names
SQL
2 votes167 views1 answer
Oracle sql merge
SQL
11 votes169 views5 answers
Sql server reset identity
SQL
3 votes144 views1 answer
Uppercase and lowercase in sql
SQL
0 vote106 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote153 views1 answer
Char varchar nvarchar sql
SQL
1 vote156 views1 answer
Oracle difference between two dates in years
SQL
0 vote150 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL