📣

TiDB Cloud Serverless 现已更名为
Starter
!此页面由 AI 自动翻译,英文原文请见
此处。

SHOW CREATE DATABASE

SHOW CREATE DATABASE 用于显示重新创建现有数据库的确切 SQL 语句。SHOW CREATE SCHEMA 是它的同义词。

语法

ShowCreateDatabaseStmt:

ShowCreateDatabaseStmt
SHOWCREATEDATABASESCHEMAIFNOTEXISTSDBName

示例

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

相关链接

文档内容是否有帮助?