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 vote216 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
7 votes207 views1 answer
Oracle reset sequence
SQL
0 vote211 views1 answer
Where case insensitive like mysql
SQL
1 vote220 views1 answer
Table information in sql server
SQL
6 votes206 views1 answer
Sqlite foreign key
SQL
16 votes220 views2 answers
Add column if not exists mysql
SQL
0 vote228 views1 answer
Raiserror with nowait
SQL
0 vote235 views1 answer
Sparql if bound query
SQL
0 vote237 views1 answer
Mysql insert into select transaction c#
SQL
0 vote208 views1 answer
Sql select most frequent value in group
SQL