导入出错,要怎么修改?请高手帮忙一下,我是一个新手,不知道怎么改?
/*
Navicat MySQL Data Transfer
Source Server : aliyun_rds
Source Server Version : 50616
Source Host : rm-2ze0s4b07mvt46dmtco.mysql.rds.aliyuncs.com:3306
Source Database : demo
Target Server Type : MYSQL
Target Server Version : 50616
File Encoding : 65001
Date: 2019-04-19 14:25:41
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for pre_forum_collection
-- ----------------------------
DROP TABLE IF EXISTS `pre_forum_collection`;
CREATE TABLE `pre_forum_collection` (
`ctid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`username` varchar(15) NOT NULL DEFAULT '',
`name` varchar(50) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`follownum` mediumint(8) unsigned NOT NULL DEFAULT '0',
`threadnum` mediumint(8) unsigned NOT NULL DEFAULT '0',
`commentnum` mediumint(8) unsigned NOT NULL DEFAULT '0',
`desc` text NOT NULL DEFAULT '',
`lastupdate` int(10) unsigned NOT NULL DEFAULT '0',
`rate` float NOT NULL DEFAULT '0',
`ratenum` mediumint(8) unsigned NOT NULL DEFAULT '0',
`lastpost` mediumint(8) unsigned NOT NULL DEFAULT '0',
`lastsubject` varchar(80) NOT NULL DEFAULT '',
`lastposttime` int(10) unsigned NOT NULL DEFAULT '0',
`lastposter` varchar(15) NOT NULL DEFAULT '',
`lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
`keyword` varchar(255) NOT NULL DEFAULT '',
`pagetitle` varchar(255) NOT NULL DEFAULT '' COMMENT '页面标题',
`pagedesc` varchar(500) NOT NULL DEFAULT '' COMMENT '页面描述信息',
`thumb` varchar(255) NOT NULL DEFAULT '' COMMENT '封面',
`html` text NOT NULL DEFAULT '',
`shownum` int(11) NOT NULL DEFAULT '0' COMMENT '显示数量',
PRIMARY KEY (`ctid`),
KEY `dateline` (`dateline`),
KEY `hotcollection` (`threadnum`,`lastupdate`),
KEY `follownum` (`follownum`),
KEY `uid` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
已经解决,应该是格式问题