Basic MySQL tips #1

History

MySQLAdmin maintains a history, accessible with the up and down arrows. And it works between sessions.

Which is nice.

Show all the (user) tables

> show tables;

Describe a specific table (e.g. users table):

> describe users;