Common Data Types
| Type | Description |
|---|---|
| INTEGER | Whole numbers |
| TEXT/VARCHAR | Text strings |
| REAL/FLOAT | Decimal numbers |
| DATE | Date values |
| BOOLEAN | True/False |
sql
1CREATE TABLE products (
2 id INTEGER,
3 name VARCHAR(100),
4 price REAL,
5 created DATE
6);
| Type | Description |
|---|---|
| INTEGER | Whole numbers |
| TEXT/VARCHAR | Text strings |
| REAL/FLOAT | Decimal numbers |
| DATE | Date values |
| BOOLEAN | True/False |
1CREATE TABLE products (
2 id INTEGER,
3 name VARCHAR(100),
4 price REAL,
5 created DATE
6);