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 vote74 views1 answer
Sql truncate table referencing itself
SQL
0 vote122 views2 answers
Mysql select date from datetime
SQL
1 vote189 views2 answers
Coderbyte sql solutions
SQL
0 vote123 views1 answer
Create a view in sqlite
SQL
0 vote120 views1 answer
Supprimer les valeur d'une table mysql
SQL
1 vote126 views2 answers
Procedure syntax
SQL
1 vote115 views1 answer
Sql restore backup query
SQL
1 vote108 views10 answers
Stack overflow
SQL
0 vote125 views1 answer
Sql max of two values
SQL
0 vote155 views1 answer
Capabilities of sql select statements
SQL