Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Using Database-Related SHOW Statements

mysql> SHOW CREATE DATABASE <database name> mysql> mysql> SHOW CREATE DATABASE mysql; +----------+------------------------------------------------------------------+ | Database | Create Database                                                  | +----------+------------------------------------------------------------------+ | mysql    | CREATE DATABASE `mysql` /*!40100 DEFAULT CHARACTER SET latin1 */ | +----------+------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql>