MySQL Hints
From SnOwy - Ed's Wiki Notebook
Here's a list of commands I often have to look up.
Contents |
List of Users
select User from mysql.user;
List of Databases
show databases; show schemas;
List of Tables
show tables in <db_name>;
List of Columns
show columns in <db_name.table_name>
