Comparison of PostgreSQL and MySQL

From WhyNotWiki

Jump to: navigation, search

This is for people who, like me, have to use both databases and have to keep the differences between them straight.

This is mostly to document syntax differences, so that in case you are used to doing say SELECT * INTO syntax in PotgreSQL, you can quickly find the MySQL analog.

PostgreSQL MySQL
SELECT * INTO old_zips FROM zips; CREATE TABLE old_zips SELECT * FROM zips;
upper() ?
Retrieved from "http://whynotwiki.com/Comparison_of_PostgreSQL_and_MySQL"
Personal tools