SHOW CREATE DATABASE displays the CREATE DATABASE statement that creates a given database : COLLATION Character Set : Table MySQL TUTORIALS

MySQL TUTORIALS » Table » COLLATION Character Set »

SHOW CREATE DATABASE displays the CREATE DATABASE statement that creates a given database


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

mysql>