SQLite more laid back than the D-O-double-G

SQLite only supports a simple set of data types and the only one that really matters is “INTEGER PRIMARY KEY” so you can have it auto-increment. In fact, by default, I can declare the columns as anything I want and it doesn’t even throw a warning.

sqlite> CREATE TABLE t2(c1 wtf, c2 yomama);
sqlite> INSERT INTO [...]

Also tagged