I don't think you can add multiple columns in just one command.

/Jonas

On Sat, Oct 25, 2008 at 2:34 PM, 灵感之源 <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
>      I want to add multiple columns, the following works for only one
> column:
>
>      ALTER TABLE Data ADD COLUMN Password TEXT
>
>      but not this:
>
>       ALTER TABLE Data ADD COLUMN (Password TEXT, User TEXT)
>
>       nor this:
>
>       ALTER TABLE Data ADD (Password TEXT, User TEXT)
>
>
> --
> Regards
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to