Movatterモバイル変換

SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS]db_name

Shows theCREATE DATABASE statement that creates the named database. If theSHOW statement includes anIF NOT EXISTS clause, the output too includes such a clause.SHOW CREATE SCHEMA is a synonym forSHOW CREATE DATABASE.

mysql> SHOW CREATE DATABASE test\G*************************** 1. row ***************************       Database: testCreate Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4                 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION='N' */mysql> SHOW CREATE SCHEMA test\G*************************** 1. row ***************************       Database: testCreate Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4                 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION='N' */

SHOW CREATE DATABASE quotes table and column names according to the value of thesql_quote_show_create option. SeeSection 7.1.8, “Server System Variables”.