Sqlite: ALTER TABLE ADD COLUMN fail on OSX 10.4

I've been playing with some stuff in Django recently and having updated a model I wanted to add a column to the sqlite database. Unfortunately ALTER TABLE ADD COLUMN statements don't work in sqlite3.1.3 which is the version installed in Tiger and all you'll get is a SQL error message.

sqlite> ALTER TABLE snippets_snippet ADD COLUMN 'code' text;
SQL error: near "ADD": syntax error

So how to fix this? Good news fink install sqlite3 will get you version 3.2.8 and you'll find it in /sw/bin/sqlite3

Show Comments