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 vote208 views2 answers
Mysql cast to varchar
SQL
1 vote179 views1 answer
Load mysql dumb
SQL
0 vote179 views1 answer
Sql count more than 1
SQL
3 votes156 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
15 votes162 views2 answers
How to drop database name in postgresql
SQL
0 vote165 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
1 vote190 views1 answer
Set id count mysql
SQL
3 votes156 views1 answer
Mysql UPDate with enner join
SQL
1 vote170 views1 answer
Oracle sql assign unique number to each grouping
SQL
-1 vote156 views2 answers
Sql query examples
SQL