Data Type in SQLite-Basic SQLite tutorial (2)

To use a database, you must first find out its data type, isn't it? SQLite data type and its simplicity:

• Null. Null

• Integer. Integer

• Real. Floating Point Type

• Text. Text Type

• Blob. Binary type, used to store files.

The above is the SQLite storage type. Of course, each type has a different sub-type based on the data length. This is not mentioned now, because you can directly use these big types. You know the types. In the future, you will be familiar with it in practical use.

SQLite does not require you to declare the Data Type in advance. In actual stored procedures, it will automatically convert data based on the actual type. However, we do not recommend non-datatype to improve efficiency.

The following is a code for creating a table. It mainly helps you understand the practical use of data types:

Create Table student (Name text, // name no integer, // student ID totalscore real, // total score photo blob // photo );