CodeNewbie Community 🌱

Tip Season
Tip Season

Posted on

Postgres Vs MySQL syntax comparison with cheatsheet

When migrating from PostgreSQL to MySQL we often get stuck with syntax between databases. Here are the top commands that we often use during real world projects.

  1. Show a list of all databases in PostgreSQL vs MySQL
  2. Use or Change database in PostgreSQL vs MySQL
  3. Show schemas in PostgreSQL vs MySQL
  4. Show a list of all tables in PostgreSQL vs MySQL
  5. Describe table in PostgreSQL vs MySQL
  6. Show create table in PostgreSQL vs MySQL
  7. Show list of users or roles in PostgreSQL vs MySQL
  8. Show process list in PostgreSQL vs MySQL
  9. Comments, Quotes, Case sensitivity in PostgreSQL VS MySQL

To have a detailed comparison I have created a blog post with examples. You can check it out here:

https://tipseason.com/postgres-vs-mysql-syntax-comparision/

Note: This page has link to one page cheatsheet too.

Would you like to learn about other queries ? Comment below.

Oldest comments (0)