SQL – Select, Order, and Limit Specified Entries from a Table
A typical SELECT statement will include WHERE, ORDER BY, and LIMIT keywords to retrieve only the rows that apply.
SQL – Show all Databases on the Server
This shows all databases on the server, and is handy when looking for a specific database in the system or if you’re acclimating yourself to a new system.