sqlite alter table add MULTIPLE columns in a single statement

by

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.

More Related Contents:

  1. Selecting more than one value
  2. Is it possible to insert multiple rows at a time in an SQLite database?
  3. SQLite DateTime comparison
  4. SQLite Reset Primary Key Field
  5. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  6. Deleting duplicate rows from sqlite database
  7. What does the SQL Standard say about usage of backtick(`)?
  8. Declare variable in SQLite and use it
  9. Does SQLite3 not support foreign key constraints?
  10. How to get a list of column names on Sqlite3 database?
  11. Rename column SQL Server 2008
  12. How do I add a foreign key to an existing SQLite table?
  13. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  14. Is there AUTO INCREMENT in SQLite?
  15. Get month from DATETIME in sqlite
  16. GROUP_CONCAT in SQLite
  17. How do I import .sql files into SQLite 3?
  18. Android multiple databases open
  19. sqlite select with condition on date
  20. How to compare sqlite TIMESTAMP values
  21. How can I add a column that doesn’t allow nulls in a Postgresql database?
  22. SQlite: select into?
  23. SQLite Order By Date1530019888000
  24. SQL error: misuse of aggregate
  25. SQLite query, ‘LIKE’
  26. SQL SET DEFAULT not working in MS Access
  27. How to use a calculated column by another calculated column
  28. UPSERT *not* INSERT or REPLACE
  29. Drop column from SQLite table
  30. converting int to real in sqlite

Leave a Comment