[sqlite] alter table syntax ?

2006-02-23 Thread Doug Fajardo 
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

Re: [sqlite] alter table syntax ?

2006-02-23 Thread Kurt Welgehausen 
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