Flexible typing

The Advantages Of Flexible Typing

Here, although we declared the types of the fields, we can insert any type of value.

CREATE TABLE flexible (
    id INTEGER,
    name TEXT,
    height REAL
);

INSERT INTO flexible (id, name, height) VALUES (1, 'foo', 1.8);
INSERT INTO flexible (id, name, height) VALUES ('id', 23, 'tall');

SELECT * from flexible;

$ sqlite3 < examples/flexible-data.sql

1|foo|1.8
id|23|tall