Sqlite alter table add MULTIPLE columns in a single statement

alter-tablesqlsqlite

Is it possible to alter table add MULTIPLE columns in a single statement in sqlite?
The following would not work.

alter table test add column mycolumn1 text, add column mycolumn2 text;

Best Answer

No, you have to add them one at a time. See the syntax diagram at the top of SQLite's ALTER TABLE documentation:

ALTER TABLE syntax

There's no loop in the ADD branch so no repetition is allowed.