ProSkill/Engineer/DB/MySQL/Command

Manage Database

Show database list

show databases;
show databases like wild;

Show table list

show tables;
show tables like 'hoge%';

Display the create statement for a table

show create database ${database_name}