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

8 votes175 views2 answers
Change name of colum in sql table
SQL
0 vote187 views1 answer
How to find sql server name
SQL
2 votes180 views2 answers
Install postgresql
SQL
0 vote146 views1 answer
Delete double on SQL with multiple primary keys
SQL
1 vote116 views2 answers
Get date from datetime postgresql
SQL
0 vote160 views1 answer
Postgresql in vs any performance
SQL
1 vote147 views1 answer
Sql avg group by
SQL
0 vote145 views1 answer
Close sql query vb.net
SQL
8 votes107 views2 answers
Alter column name in mssql
SQL
7 votes163 views2 answers
N highest salary in sql
SQL