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 vote190 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
2 votes174 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote354 views1 answer
Dublicate row sql
SQL
-2 votes182 views3 answers
Sqlite reset autoincrement
SQL
15 votes168 views4 answers
How to get all tables in sql
SQL
0 vote187 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote174 views1 answer
Add created and updatedAt fields in mysql
SQL
8 votes168 views1 answer
Today minus 15 days postgresql
SQL
0 vote176 views1 answer
Print mysql
SQL
0 vote186 views1 answer
List all permissions on a table in postgres
SQL