Sqlite - Sql Grammar

About

The whole SQL syntax documentation for SQLite can be found at lang and/or full sql

List

Support

[SQLITE_ERROR] SQL error or missing database (row value misused)

This error may be caused in a group by clause if you group the columns with parentheses.

Example:

group by (col1, col2)

To resolve this issue, you need to suppress the parentheses. Example:

group by col1, col2

Powered by ComboStrap