#sql

PostgreSQL "relation does not exist": when the table is right there

Fix PostgreSQL "ERROR: relation does not exist": check the schema and search_path, quoted names with capitals, which database you are in, and whether migrations have run.

Beginner · 4 min read

ERROR 1064 (42000)

Databases

MySQL "ERROR 1064: You have an error in your SQL syntax": how to read it and fix it

Fix MySQL ERROR 1064: read the "near" text, then check reserved words like rank and groups, quotes, commas, old GRANT syntax and queries written for another database.

Beginner · 4 min read

ORA-00942

Databases

Oracle "ORA-00942: table or view does not exist": when the table is right there

Fix Oracle ORA-00942 "table or view does not exist": the table may exist. Check the schema, your privileges, quoted lowercase names, synonyms and roles inside PL/SQL.

Beginner · 3 min read

must appear in the GROUP BY clause or be used in an aggregate function

Databases

PostgreSQL "column must appear in the GROUP BY clause or be used in an aggregate function"

Fix the GROUP BY error in PostgreSQL: understand why it happens, then aggregate the column, group by it or by the primary key, or pick one row per group with DISTINCT ON.

Beginner · 3 min read

invalid input syntax for type integer

Databases

PostgreSQL "invalid input syntax for type integer": find the bad value and handle it

Fix "invalid input syntax for type integer": find empty strings and text where a number is expected, convert with NULLIF and pg_input_is_valid, import clean data.

Beginner · 3 min read