SQLite Database Related Summary

1.

SQLite is a light-weight, relational management system, is embedded, low-occupancy resources, portability, faster than MySQL processing speed, the mainstream version is now Sqlite3

2.

The data types in SQLite are text (string, utf-8,utf-16 encoded), (REAL) floating-point, (integer) signed integer, (BLOB) binary data, can hold any binary data, and several other infrequently used (VARCHAR, CHAR, CLOB) converts the type of text (FLOAT DOUBLE) into a real type (NUMERIC) into an integer)

Note: There is no Boolean type in SQLite, can be replaced with integer 0 and 1, there is no time and date type, can be replaced by text,real, etc.

3.

The basic SQL statements that are commonly used are:

--Create a table:

creat table name (Field 1, Field 2, Field 3 ...);

-If the table does not exist, then create

creat table if not EXISTS name (field 1, Field 2, Field 3 ...)

--------Delete the entire table:

DROP table Name

--------Inserting data:

Insert into table name (Field 1, Field 2, Field 3 ...). Values (value 1, value 2, value 3 ...)

---------query:

Select field name from table name---------query data for a field

SELECT * FROM table name---------all data for all fields

----------Modification:

Update table name set field name = ' new value ' where query condition

SQLite Database Related Summary