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 vote365 views1 answer
Pl sql round
SQL
1 vote392 views1 answer
Sql where max date
SQL
0 vote419 views1 answer
Sql show founctions
SQL
0 vote348 views1 answer
Sql server split string and insert into table select
SQL
26 votes299 views10 answers
Insert in to table sql
SQL
0 vote368 views1 answer
How to create a table based on another table in mysql
SQL
0 vote365 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote352 views1 answer
Mysql docker image arjun
SQL
2 votes344 views1 answer
Match in sql server
SQL
7 votes371 views2 answers
Add column table pl sql
SQL