执行show create语句的时候,是否用·包含
mysql> show variables like 'SQL_QUOTE_SHOW_CREATE';
+-----------------------+-------+| Variable_name | Value |
+-----------------------+-------+
| sql_quote_show_create | ON |
+-----------------------+-------+
1 row in set (0.00 sec)
mysql> show create table t1;
+-------+------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+------------------------------------------------------------------------------------------------------------------------+
| t1 | CREATE TABLE `t1` (
`id` int(11) DEFAULT NULL,
`name` varchar(5) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+-------+------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> set SQL_QUOTE_SHOW_CREATE=0;
Query OK, 0 rows affected (0.02 sec)
mysql> show create table t1;
+-------+--------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+--------------------------------------------------------------------------------------------------------------------+
| t1 | CREATE TABLE t1 (
id int(11) DEFAULT NULL,
`name` varchar(5) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+-------+--------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> show create database gw1;
+----------+------------------------------------------------------------+
| Database | Create Database |
+----------+------------------------------------------------------------+
| gw1 | CREATE DATABASE gw1 /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> set SQL_QUOTE_SHOW_CREATE=1;
Query OK, 0 rows affected (0.00 sec)
mysql> show create database gw1;
+----------+--------------------------------------------------------------+
| Database | Create Database |
+----------+--------------------------------------------------------------+
| gw1 | CREATE DATABASE `gw1` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+--------------------------------------------------------------+
1 row in set (0.00 sec)