标题: (求助)mysql建表报错。帮忙下！！ [打印本页] 作者: love_zxd2008 时间: 2009-11-27 12:02 标题: (求助)mysql建表报错。帮忙下！！ SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
DROP SCHEMA IF EXISTS `hs_work` ;
CREATE SCHEMA IF NOT EXISTS `hs_work` DEFAULT CHARACTER SET gb2312 COLLATE default collation ;
USE `hs_work`;
-- -----------------------------------------------------
-- Table `hs_work`.`Admin`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `hs_work`.`Admin` (
`id` INT(11) NOT NULL AUTO_INCREMENT ,
`admin_name` VARCHAR(30) NULL COMMENT '管理员 登录名' ,
`admin_pwd` VARCHAR(30) NULL COMMENT '管理员登录密码' ,
PRIMARY KEY (`id`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = gb2312
COMMENT = '管理员表';
。。。。。。。。。。。。
报的错误
ERROR 1064 （42000）You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'collaction'
at line 1
ERROR 1049(42000)