Latest web development tutorials

SQLite Autoincrement

SQLite isAUTOINCREMENT is a keyword for the field value in the table is automatically incremented.We can useAUTOINCREMENT keyword automatically increase the value of a field when you create a table on a specific column names.

KeywordAUTOINCREMENT only be used for integer (INTEGER) field.

grammar

Basic usageAUTOINCREMENT keyword is as follows:

CREATE TABLE table_name (
   column1 INTEGER AUTOINCREMENT,
   column2 datatype,
   column3 datatype,
   .....
   columnN datatype,
);

Examples

Suppose you want to create COMPANY table is as follows: 

sqlite> CREATE TABLE COMPANY (
   ID INTEGER PRIMARY KEY AUTOINCREMENT,
   NAME TEXT NOT NULL,
   AGE INT NOT NULL,
   ADDRESS CHAR (50),
   SALARY REAL
);

Now, to the COMPANY table insert the following records: 

INSERT INTO COMPANY (NAME, AGE, ADDRESS, SALARY)
VALUES ( 'Paul', 32, 'California', 20000.00);

INSERT INTO COMPANY (NAME, AGE, ADDRESS, SALARY)
VALUES ( 'Allen', 25, 'Texas', 15000.00);

INSERT INTO COMPANY (NAME, AGE, ADDRESS, SALARY)
VALUES ( 'Teddy', 23, 'Norway', 20000.00);

INSERT INTO COMPANY (NAME, AGE, ADDRESS, SALARY)
VALUES ( 'Mark', 25, 'Rich-Mond', 65000.00);

INSERT INTO COMPANY (NAME, AGE, ADDRESS, SALARY)
VALUES ( 'David', 27, 'Texas', 85000.00);


INSERT INTO COMPANY (NAME, AGE, ADDRESS, SALARY)
VALUES ( 'Kim', 22, 'South-Hall', 45000.00);

INSERT INTO COMPANY (NAME, AGE, ADDRESS, SALARY)
VALUES ( 'James', 24, 'Houston', 10000.00);

This will insert COMPANY Table 7 yuan group, the recording COMPANY table is as follows: 

ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
1 Paul 32 California 20000.0
2 Allen 25 Texas 15000.0
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0
6 Kim 22 South-Hall 45000.0
7 James 24 Houston 10000.0