Raspberry Pi 3 Cookbook for Python Programmers - Third Edition

The CREATE TABLE command

The CREATE TABLE command is used to define a new table by specifying the column names (and also to set default values, if desired):

CREATE TABLE table_name ( 
    column_name1 TEXT,  
    column_name2 INTEGER DEFAULT 0, 
    column_name3 REAL ) 

The previous SQL command will create a new table called table_name, containing three data items. One column will contain text, other integers (for example, 1, 3, -9), and finally, one column will contain real numbers (for example, 5.6, 3.1749, 1.0).