用命令行导入。sql文件
显示有错误
在CREATE TABLE `t_actors` (
`actor_id` int(10) unsigned NOT NULL auto_increment,
`actor_cn_name` varchar(30) collate utf8_unicode_ci NOT NULL,
`actor_en_name` varchar(30) collate utf8_unicode_ci default NULL,
`actor_info` text collate utf8_unicode_ci,
`settime` datetime NOT NULL,
`operate_id` int(11) NOT NULL,
PRIMARY KEY (`actor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
中的
CREATE TABLE `t_actors` (
`actor_id` int(10) unsigned NOT NULL auto_increment,有错误,为什么
显示有错误
在CREATE TABLE `t_actors` (
`actor_id` int(10) unsigned NOT NULL auto_increment,
`actor_cn_name` varchar(30) collate utf8_unicode_ci NOT NULL,
`actor_en_name` varchar(30) collate utf8_unicode_ci default NULL,
`actor_info` text collate utf8_unicode_ci,
`settime` datetime NOT NULL,
`operate_id` int(11) NOT NULL,
PRIMARY KEY (`actor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
中的
CREATE TABLE `t_actors` (
`actor_id` int(10) unsigned NOT NULL auto_increment,有错误,为什么
此SQL语句没有问题
CREATE TABLE `t_actors` (
`actor_id` int unsigned NOT NULL auto_increment,
`actor_cn_name` varchar(30) collate utf8_unicode_ci NOT NULL,
`actor_en_name` varchar(30) collate utf8_unicode_ci default NULL,
`actor_info` text collate utf8_unicode_ci,
`settime` datetime NOT NULL,
`operate_id` int(11) NOT NULL,
PRIMARY KEY (`actor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;