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

1. MySQL Tutorial
2. Table
3. COLLATION Character Set

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>