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

1 vote372 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote128 views1 answer
Exec procedure oracle
SQL
1 vote128 views3 answers
Union SQL
SQL
0 vote131 views2 answers
Script all indexes in a database
SQL
1 vote120 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote117 views1 answer
How change the field place in mysql
SQL
0 vote121 views1 answer
Sql character index
SQL
0 vote121 views1 answer
Python mysql query where
SQL
0 vote151 views1 answer
Sqlite trim
SQL
1 vote147 views1 answer
How to get previous year from sysdate in oracle
SQL