SELECT INTO statement in sqlite

by

Instead of

SELECT * INTO equipments_backup FROM equipments

try

CREATE TABLE equipments_backup AS SELECT * FROM equipments

More Related Contents:

  1. near “varchar”: syntax error [closed]
  2. How do I make an UPDATE while joining tables on SQLite?
  3. How do I rename a column in a SQLite database table?
  4. How do I check in SQLite whether a table exists?
  5. How to set Sqlite3 to be case insensitive when string comparing?
  6. Escape single quote character for use in an SQLite query
  7. Difference between 2 dates in SQLite
  8. Update with Join in SQLite
  9. Can I read and write to a SQLite database concurrently from multiple connections?
  10. How do I store and retrieve a blob from sqlite?
  11. SQLite error ‘attempt to write a readonly database’ during insert?
  12. Sqlite primary key on multiple columns
  13. Store boolean value in SQLite
  14. Can SQLite support multiple users?
  15. SQLite add Primary Key
  16. Encrypted cookies in Chrome
  17. How delete table inner join with other table in Sqlite?
  18. Export from sqlite to csv using shell script
  19. ALTER TABLE ADD COLUMN IF NOT EXISTS in SQLite
  20. Create table in SQLite only if it doesn’t exist already
  21. How do DATETIME values work in SQLite?
  22. Add ON DELETE CASCADE behavior to an sqlite3 table after it has been created
  23. sqlite get ROWID
  24. How to set unique constraint over multiple columns when any one can be null?
  25. Will SQLite performance degrade if the database size is greater than 2 gigabytes?
  26. SQLite for large data sets?
  27. sql query – how to apply limit within group by
  28. SQLite database supporting Unicode data
  29. Creating stored procedure in SQLite
  30. SQLITE3 VACUUM, “database or disk is full”

Leave a Comment