Autoincrement values in column in SQLite database

Question

Tarun Kumar · Accepted Answer

"Use this- SQLite autoincrement syntax, at the time of table definition:CREATE TABLE EMPLOYEE(id INTEGER PRIMARY EKY AUTOINCREMENT, name TEXT NOT NULL, age INT NOT NULL);To insert values into this EMPLOYEE table, use syntax like this:INSERT INTO EMPLOYEE (name, age) VALUES ('JOHN',25);Column 'id' will increment its values by autoincrement feature of SQLite database.(by default increment will be from 1, and so on)"

Tarun Kumar · Answer

Use this- SQLite autoincrement syntax, at the time of table definition:
CREATE TABLE EMPLOYEE(id INTEGER PRIMARY EKY AUTOINCREMENT, name TEXT NOT NULL, age INT NOT NULL);

To insert values into this EMPLOYEE table, use syntax like this:
INSERT INTO EMPLOYEE (name, age) VALUES ('JOHN',25);
Column 'id' will increment its values by autoincrement feature of SQLite database.(by default increment will be from 1, and so on)

forum

Autoincrement values in column in SQLite database

Can you answer this question?

1 Answers