Table MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Table
  4. 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>