SQLite 3

SQLite 3
NovemcontrolsSQLite 3

SQLite 3

A standalone command-line shell program called sqlite3 is provided in SQLite's distribution. It can be used to create a database, define tables, insert and change rows, run queries and manage an SQLite database file. It also serves as an example for writing applications that use the SQLite library.

Novemcontrols
Novemcontrols
Novemcontrols

NULL

It is a NULL value.

Novemcontrols
Novemcontrols

INTEGER

It is an integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the value.

Novemcontrols
Novemcontrols

REAL

It is a floating point value, stored as an 8-byte floating number.

Novemcontrols
Novemcontrols

TEXT

It is a string, stored using the database encoding (UTF).