在服务器中执行SQL脚本
错误:错误1628:表’customer’的注释太长(最大值= 60)
脚本:
CREATE TABLE IF NOT EXISTS `sakila`.`customer` ( `customer_id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT , `store_id` TINYINT(3) UNSIGNED NOT NULL , `first_name` VARCHAR(45) NOT NULL , `last_name` VARCHAR(45) NOT NULL , `email` VARCHAR(50) NULL DEFAULT NULL , `address_id` SMALLINT(5) UNSIGNED NOT NULL , `active` TINYINT(1) NOT NULL DEFAULT TRUE , `create_date` DATETIME NOT NULL , `last_update` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`customer_id`) , INDEX `idx_fk_store_id` (`store_id` ASC) , INDEX `idx_fk_address_id` (`address_id` ASC) , INDEX `idx_last_name` (`last_name` ASC) , CONSTRAINT `fk_customer_address` FOREIGN KEY (`address_id` ) REFERENCES `sakila`.`address` (`address_id` ) ON DELETE RESTRICT ON UPDATE CASCADE, CONSTRAINT `fk_customer_store` FOREIGN KEY (`store_id` ) REFERENCES `sakila`.`store` (`store_id` ) ON DELETE RESTRICT ON UPDATE CASCADE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8
评论 ‘表存储所有客户。拥有指向该客户注册的地址表和商店表的外键。\ n \ n有关客户的基本信息(例如名字和姓氏)存储在表本身中。创建记录的日期和信息的最后更新时间相同。
SQL脚本执行完成:语句:成功3次,失败1次
As stated in the MySQL docs, a comment is limited to 255 characters: http://dev.mysql.com/doc/refman/5.1/en/create-table.html#id3411882. Your comment is 305 characters, and it would seem, from the error message, that your particular MySQL install has a 60 character limit.