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

13 votes175 views2 answers
Sql join
SQL
8 votes215 views3 answers
Find table for column name in sql
SQL
0 vote209 views1 answer
Rows, INSERT INTO, Returning
SQL
5 votes182 views1 answer
Oracle list functions
SQL
1 vote172 views1 answer
Set statistics on in ssms
SQL
4 votes177 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote179 views1 answer
Sql grant select only
SQL
3 votes191 views1 answer
Postgres kill running query
SQL
0 vote196 views1 answer
Sqlite unique multiple columns
SQL
0 vote191 views3 answers
Mysql regex replace
SQL