SQLite Forum

create taable with syntax error works ?
I dont expect sqlite to map other dbms column types

I was just surprised that there wasnt any apparent error warning or any other indication that I had missed a single comma
Every other DB I've used for the last nearly 40 years (many of those N other db's you refer to ) gives me an error

> So you should use that if it is too hard to remember to separate your column definitions as SQL requires.

This sort of left handed jab really isnt necessary

I indeed thought I HAD correctly specified my columns and actually hunted code elsewhere for the issue long before I even noticed the single missing comma in about 100K lines of code

STRICT mode will be welcome