SHOW DATABASES; -- examine list of supported databases USE mydata; -- select mydata database. Does not work in PostgreSQL. SHOW TABLES; -- examine tables in mydata database. Does not work in PostgreSQL. DESCRIBE animals; -- look at column descriptions in the animals table CREATE DATABASE plants; -- create a new database. SELECT * FROM animals; -- display the entire animals table.