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

6 votes101 views2 answers
Oracle undotbs usage
SQL
4 votes131 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
1 vote116 views1 answer
Increase existing date in sql
SQL
0 vote115 views1 answer
How to insert multiple rows in mysql using laravel
SQL
1 vote124 views2 answers
How to combine 2 tables in MySQL
SQL
4 votes149 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote91 views1 answer
Mariadb set vertical output format
SQL
0 vote110 views1 answer
How to make full text search dynamic in mysql
SQL
5 votes103 views1 answer
Sqlite alter table add column
SQL
0 vote134 views1 answer
Update sql sintax
SQL