MySQL Cheat Sheet

This is just a quick cheat sheet for folks unfamiliar with Postgres. This tutorial is also really helpful.

List all Databases

show databases;

List all tables in a DB

• First connect to the db use <dbname>;
• Then list all tables show tables;

View all rows and columns of a table

SELECT * FROM <tablename>