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>