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 vote126 views1 answer
Mysql database is not starting in xampp
SQL
2 votes128 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote140 views1 answer
How to check xampp mysql password
SQL
0 vote135 views1 answer
Sql datediff db2
SQL
1 vote135 views1 answer
Drush sql-dump
SQL
5 votes147 views3 answers
Bash: mysql: command not found
SQL
5 votes133 views1 answer
Postgresql functions
SQL
0 vote102 views2 answers
Spring properties file for db
SQL
0 vote145 views3 answers
How to run sql query
SQL
2 votes146 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL