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