How to automatically increment the 'Id' row of a table ?

You use in the table Column constraints AUTO_INCREMENT and IDENTITY that associate a column with a sequence. This sequence automatically increments the column value as new rows are added.

If you use SQL Server you follow IDENTITY keyword to auto increment Feature.

For Example:

CREATE TABLE Employee(
empId int IDENTITY(1,1) PRIMARY KEY,
LastName varchar(150) NOT NULL,
FirstName varchar(150)
);
IDENTITY(1,1) means number start from 1 and it increment by 1, if you want increment by 2 field then set IDENTITY(1,2).

If you use MySQL you follow AUTO_INCREMENT keyword to auto increment Feature.when you add new data , it automatically increments by 1.

For Example,

CREATE TABLE Employee(
empId int NOT NULL AUTO_INCREMENT,
LastName varchar(150) NOT NULL,
FirstName varchar(150),
PRIMARY KEY (empId)
);

If you do not want to modify table then go with jquey.Jquery automatically increament your id by 1.

Full code, guildline and demo available on codepen website:

https://codepen.io/peker-ercan/pen/qJObwy

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Hi, Please use this link, https://www.edureka.co/blog/sql-auto-increment/
0
Akshay Shedwad6y ago
You use in the table Column constraints AUTO_INCREMENT and IDENTITY that associate a column with a sequence. This sequence automatically increments the column value as new rows are added.

If you use SQL Server you follow IDENTITY keyword to auto increment Feature.

For Example:
CREATE TABLE Employee(
empId int IDENTITY(1,1) PRIMARY KEY,
LastName varchar(150) NOT NULL,
FirstName varchar(150)
);
IDENTITY(1,1) means number start from 1 and it increment by 1, if you want increment by 2 field then set IDENTITY(1,2).
If you use MySQL you follow AUTO_INCREMENT keyword to auto increment Feature.when you add new data , it automatically increments by 1.

For Example,
CREATE TABLE Employee(
empId int NOT NULL AUTO_INCREMENT,
LastName varchar(150) NOT NULL,
FirstName varchar(150),
PRIMARY KEY (empId)
);
If you do not want to modify table then go with jquey.Jquery automatically increament your id by 1.

Full code, guildline and demo available on codepen website:

https://codepen.io/peker-ercan/pen/qJObwy
+2
Vertika Chauhan6y ago
Set the id column property as identity
0