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  statement in Sqlite v2.x;
switch to v3 if you need it.

Regards

[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>