网站搬家,在新的 数据库中导入旧的数据库,执行的时候出现错误如下:
SQL 查询:
--
-- 数据库: `wordpress`
--
-- --------------------------------------------------------
--
-- 表的结构 `wp_commentmeta`
--
CREATE TABLE IF NOT EXISTS `wp_commentmeta` (`meta_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`comment_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0',
`meta_key` VARCHAR( 255 ) DEFAULT NULL ,
`meta_value` LONGTEXT,
PRIMARY KEY ( `meta_id` ) ,
KEY `comment_id` ( `comment_id` ) ,
KEY `meta_key` ( `meta_key` )) TYPE = INNODB AUTO_INCREMENT =1;
MySQL 返回:#1064 - 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 'TYPE=InnoDB AUTO_INCREMENT=1' at line 19
是怎么回事,有谁知道怎么解决吗?
SQL 查询:
--
-- 数据库: `wordpress`
--
-- --------------------------------------------------------
--
-- 表的结构 `wp_commentmeta`
--
CREATE TABLE IF NOT EXISTS `wp_commentmeta` (`meta_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`comment_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0',
`meta_key` VARCHAR( 255 ) DEFAULT NULL ,
`meta_value` LONGTEXT,
PRIMARY KEY ( `meta_id` ) ,
KEY `comment_id` ( `comment_id` ) ,
KEY `meta_key` ( `meta_key` )) TYPE = INNODB AUTO_INCREMENT =1;
MySQL 返回:#1064 - 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 'TYPE=InnoDB AUTO_INCREMENT=1' at line 19
是怎么回事,有谁知道怎么解决吗?