Tag
SQL differences
MySQL examples often quote every name in backticks, as in SELECT `name` FROM `people`. Copied into a PostgreSQL project, the query fails. `name` is MySQL’s way of quoting …
SQL differences
In a line like SELECT price --discount, left over from debugging, SQLite and PostgreSQL read --discount as a comment. MySQL and MariaDB add the discount to the price …
SQL differences
A query copied from PostgreSQL that puts a column name in double quotes runs on MySQL without an error, and never reads the column. Standard SQL quotes names with double …
SQL differences
MySQL and MariaDB skip everything from a # to the end of the line. On SQLite and PostgreSQL that # is still part of the statement. Scripts written for the mysql client …
SQL differences
SELECT SUM(amount) AS Total gives a column named Total on SQLite, MySQL and MariaDB. PostgreSQL calls it total. SQLite, MySQL and MariaDB return names as written. …