[sqlite] how to add multiple columns at a time

[灵感之源]

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