This content originally appeared on DEV Community and was authored by Tip Season
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.
This content originally appeared on DEV Community and was authored by Tip Season
Tip Season | Sciencx (2022-06-22T01:38:37+00:00) Postgres Vs MySQL syntax comparison with cheatsheet. Retrieved from https://www.scien.cx/2022/06/22/postgres-vs-mysql-syntax-comparison-with-cheatsheet/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.