SHOW CREATE DATABASE
SHOW CREATE DATABASE 用于显示重新创建现有数据库的确切 SQL 语句。SHOW CREATE SCHEMA 是它的同义词。
语法
ShowCreateDatabaseStmt:
- ShowCreateDatabaseStmt
示例
CREATE DATABASE test;Query OK, 0 rows affected (0.12 sec)SHOW CREATE DATABASE test;+----------+------------------------------------------------------------------+
| Database | Create Database |
+----------+------------------------------------------------------------------+
| test | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 */ |
+----------+------------------------------------------------------------------+
1 row in set (0.00 sec)SHOW CREATE SCHEMA IF NOT EXISTS test;+----------+-------------------------------------------------------------------------------------------+
| Database | Create Database |
+----------+-------------------------------------------------------------------------------------------+
| test | CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 */ |
+----------+-------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)MySQL 兼容性
SHOW CREATE DATABASE 预计与 MySQL 完全兼容。如果你发现任何兼容性差异，可以 report a bug。