Unfindable SQLite Syntax Error

by

Transaction is one of the reserved names in SQLite. For a full list see here.

Ways to solve this issue are:

  • Change the Table name to a word that isn’t reserved.

or

  • Quote the reserved name by using one of these 4 listed quote marks
    • ‘keyword’
    • “keyword”
    • `keyword`

More Related Contents:

  1. Is it possible to insert multiple rows at a time in an SQLite database?
  2. SQLite DateTime comparison
  3. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  4. What are valid table names in SQLite?
  5. Deleting duplicate rows from sqlite database
  6. What does the SQL Standard say about usage of backtick(`)?
  7. Delete column from SQLite table
  8. Declare variable in SQLite and use it
  9. sqlite database default time value ‘now’
  10. How do I insert datetime value into a SQLite database?
  11. How to get a list of column names on Sqlite3 database?
  12. basic recursive query on sqlite3?
  13. SQLite and custom order by
  14. SQLite auto-increment non-primary key field
  15. GROUP_CONCAT in SQLite
  16. How to do IF NOT EXISTS in SQLite
  17. Core Data Performance with Single Parent Entity
  18. Match only entire words with LIKE?
  19. What is causing Foreign Key Mismatch error?
  20. How to split comma-separated values?
  21. sqlite select with condition on date
  22. How to compare sqlite TIMESTAMP values
  23. SQLite Order By Date1530019888000
  24. SQL – Inserting a row and returning primary key
  25. SQL error: misuse of aggregate
  26. SQLite query, ‘LIKE’
  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