HTML tutorial
CSS3 tutorial
Bootstrap tutorial
JavaScript tutorial
JQuery tutorial
AngularJS tutorial
React tutorial
NodeJS tutorial
PHP tutorial
Python tutorial
Python3 tutorial
Django tutorial
Linux tutorial
Docker tutorial
Ruby tutorial
Java tutorial
C tutorial
C ++ tutorial
Perl tutorial
JSP tutorial
Lua tutorial
Scala tutorial
Go tutorial
ASP.NET tutorial
C # tutorial
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.
Basic usageAUTOINCREMENT keyword is as follows:
CREATE TABLE table_name ( column1 INTEGER AUTOINCREMENT, column2 datatype, column3 datatype, /en/en. columnN datatype, );
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