How to use show create database statement in mysql

qwfys200

已于 2023-05-25 21:49:23 修改

阅读量4k

点赞数 2

CC 4.0 BY-SA版权

分类专栏： RDS 文章标签： show create database mysql

于 2018-06-24 23:57:56 首次发布

知识在分享中升华，思想在交流中沉淀。

本文链接：https://blog.youkuaiyun.com/qwfys200/article/details/80796051

RDS 专栏收录该内容

32 篇文章

订阅专栏

本文介绍如何使用MySQL命令行客户端工具查询指定数据库的创建语句。通过SHOW CREATE DATABASE命令可以轻松获取相关信息，并支持IF NOT EXISTS条件判断。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

很多时候，我们想在命令行客户端工具中查阅一下某些表完整的建库语句是什么，这个时候，命令SHOW CREATE DATABASE就可以派上用场了，那么这个语句完整的语法是什么样的呢，我们下来看一下：

mysql> help show create database;
Name: 'SHOW CREATE DATABASE'
Description:
Syntax:
SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name

Shows the CREATE DATABASE statement that creates the named database. If
the SHOW statement includes an IF NOT EXISTS clause, the output too
includes such a clause. SHOW CREATE SCHEMA is a synonym for SHOW CREATE
DATABASE.

URL: http://dev.mysql.com/doc/refman/5.7/en/show-create-database.html

Examples:
mysql> SHOW CREATE DATABASE test\G
*************************** 1. row ***************************
       Database: test
Create Database: CREATE DATABASE `test`
                 /*!40100 DEFAULT CHARACTER SET latin1 */

mysql> SHOW CREATE SCHEMA test\G
*************************** 1. row ***************************
       Database: test
Create Database: CREATE DATABASE `test`
                 /*!40100 DEFAULT CHARACTER SET latin1 */

mysql> 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 schema test;
+----------+------------------------------------------------------------------+
| Database | Create Database                                                  |
+----------+------------------------------------------------------------------+
| test     | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 */ |
+----------+------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>