"Doug Fajardo" <[EMAIL PROTECTED]> wrote: > Help! > I keep getting a syntax error from the 'alter table' sql command, when > used to add a column to a table. Can someone help with this error? Below > is an example of one attempt, and its results: > > [tuna]$ sqlite test2.db > SQLite version 2.8.16 > Enter ".help" for instructions > sqlite> create table x1 ( name ); > sqlite> alter table x1 add column ( phone ); > SQL error: near "alter": syntax error > sqlite>
There's no <alter table> statement in Sqlite v2.x; switch to v3 if you need it. Regards