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.
- Show a list of all databases in PostgreSQL vs MySQL
- Use or Change database in PostgreSQL vs MySQL
- Show schemas in PostgreSQL vs MySQL
- Show a list of all tables in PostgreSQL vs MySQL
- Describe table in PostgreSQL vs MySQL
- Show create table in PostgreSQL vs MySQL
- Show list of users or roles in PostgreSQL vs MySQL
- Show process list in PostgreSQL vs MySQL
- 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.
Top comments (0)