Formed in 2009, the Archive Team (not to be confused with the archive.org Archive-It Team) is a rogue archivist collective dedicated to saving copies of rapidly dying or deleted websites for the sake of history and digital heritage. The group is 100% composed of volunteers and interested parties, and has expanded into a large amount of related projects for saving online and digital history.
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.
Discussion (0)