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 vote201 views1 answer
Check for directory in bash
SQL
6 votes198 views2 answers
Postgresql database url
SQL
2 votes189 views1 answer
Alter table add multiple columns postgresql
SQL
0 vote191 views1 answer
Execute sql stored procedure in powershell
SQL
94 votes416 views4 answers
Create database postgres
SQL
0 vote199 views1 answer
How to check common records in 2 table
SQL
0 vote234 views1 answer
Sql select rows with different values in one column
SQL
0 vote203 views1 answer
Uncheck constraints and delete from table
SQL
-2 votes211 views1 answer
How to open database
SQL
6 votes252 views2 answers
Install psql mac
SQL