-- ----------------------------
-- 创建数据库
-- ----------------------------
CREATE DATABASE ss_log default charset=utf8;
SET FOREIGN_KEY_CHECKS=0;
USE ss_log;
-- ----------------------------
-- 游戏服务器信息
-- ----------------------------
DROP TABLE IF EXISTS `server`;
CREATE TABLE `server` (
`key` varchar(50) NOT NULL COMMENT '列',
`value` varchar(100) NOT NULL DEFAULT '' COMMENT '值',
PRIMARY KEY (`key`),
KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='游戏服务器信息 20120308';这是我要执行的ss_log.sql 文件的内容为什么COMMENT 后面的会出现乱码???
-- ----------------------------
SET NAMES utf8;-- 创建数据库
-- ----------------------------
CREATE DATABASE ss_log default charset=utf8;
SET FOREIGN_KEY_CHECKS=0;
USE ss_log;
-- ----------------------------
-- 游戏服务器信息
-- ----------------------------
DROP TABLE IF EXISTS `server`;
CREATE TABLE `server` (
`key` varchar(50) NOT NULL COMMENT '列',
`value` varchar(100) NOT NULL DEFAULT '' COMMENT '值',
PRIMARY KEY (`key`),
KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='游戏服务器信息 20120308';
-- ----------------------------
SET NAMES utf8;-- 创建数据库
-- ----------------------------
CREATE DATABASE ss_log default charset=utf8;
SET FOREIGN_KEY_CHECKS=0;
USE ss_log;
-- ----------------------------
-- 游戏服务器信息
-- ----------------------------
DROP TABLE IF EXISTS `server`;
CREATE TABLE `server` (
`key` varchar(50) NOT NULL COMMENT '列',
`value` varchar(100) NOT NULL DEFAULT '' COMMENT '值',
PRIMARY KEY (`key`),
KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='游戏服务器信息 20120308';
-> `key` varchar(50) NOT NULL COMMENT '列',
-> `value` varchar(100) NOT NULL DEFAULT '' COMMENT '值',
-> PRIMARY KEY (`key`),
-> KEY `value` (`value`)
-> ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='游戏服务器信息 20120308';
Query OK, 0 rows affected (0.12 sec)mysql> show create table server;
+--------+----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------+
| Table | Create Table
|
+--------+----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------+
| server | CREATE TABLE `server` (
`key` varchar(50) NOT NULL COMMENT '列',
`value` varchar(100) NOT NULL DEFAULT '' COMMENT '值',
PRIMARY KEY (`key`),
KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='游戏服务器信息 20120308' |
+--------+----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------+
1 row in set (0.00 sec)mysql>