Try it Yourself: SQL Auto Increment – Hyring Learn

LessonBack to lesson

SQL Auto Increment

Language: SQL

CREATE TABLE Employees (
  EmployeeID INT NOT NULL AUTO_INCREMENT,
  FirstName VARCHAR(50),
  LastName VARCHAR(50),
  PRIMARY KEY (EmployeeID)
);

INSERT INTO Employees (FirstName, LastName)
VALUES ('Asha', 'Menon');

CREATE TABLE Employees (
  EmployeeID INT NOT NULL AUTO_INCREMENT,
  FirstName VARCHAR(50),
  LastName VARCHAR(50),
  PRIMARY KEY (EmployeeID)
);

INSERT INTO Employees (FirstName, LastName)
VALUES ('Asha', 'Menon');

Output

Click Run to execute this code.