我有一个.sql文件,我想将它加载到MySQL数据库中 . 我不知道它是从哪个数据库(MySQL或MS-SQL)创建的 .
现在,我试图将该文件导入MySQL数据库 . 导入和执行该文件时显示错误 .
Q1 . 所以,我的问题是从MySQL和MS-SQL生成的.sql文件是否不同?
注意:我使用SQLYog软件(MySQL的图形界面)导入文件 .
Here is the ERROR:
查询:CREATE TABLE广告(id bigint(20)NOT NULL auto_increment,city_id int(11)NOT NULL,type text collate utf8_bin NOT NULL,town text collate utf8_bin NOT NULL,address text collate utf8_bin NOT NULL,price text collate utf8_bin NOT NULL,info text collate utf8_bin NOT NULL,链接文本collate utf8_bin NOT NULL,hasImage int(11)NOT NULL,language varchar(2)collate utf8_bin NOT NULL,time_added varchar(255)collate utf8_bin NOT NULL,PRIMARY KEY(id)) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin AUTO_INCREMENT = 1
错误发生在:2009-09-08 17:41:01行号:35错误代码:1050 - 表'广告'已经存在
查询:CREATE TABLE广告(id bigint(20)NOT NULL auto_increment,city_id int(11)NOT NULL,type text collate utf8_bin NOT NULL,town text collate utf8_bin NOT NULL,address text collate utf8_bin NOT NULL,price text collate utf8_bin NOT NULL,info text collate utf8_bin NOT NULL,链接文本collate utf8_bin NOT NULL,hasImage int(11)NOT NULL,language varchar(2)collate utf8_bin NOT NULL,time_added varchar(255)collate utf8_bin NOT NULL,PRIMARY KEY(id)) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin AUTO_INCREMENT = 1
错误发生在:2009-09-08 17:41:21行号:35错误代码:1050 - 表'广告'已经存在
查询:CREATE TABLE广告(id bigint(20)NOT NULL auto_increment,city_id int(11)NOT NULL,type text collate utf8_bin NOT NULL,town text collate utf8_bin NOT NULL,address text collate utf8_bin NOT NULL,price text collate utf8_bin NOT NULL,info text collate utf8_bin NOT NULL,链接文本collate utf8_bin NOT NULL,hasImage int(11)NOT NULL,language varchar(2)collate utf8_bin NOT NULL,time_added varchar(255)collate utf8_bin NOT NULL,PRIMARY KEY(id)) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin AUTO_INCREMENT = 1
错误发生在:2009-09-08 17:41:35行号:35错误代码:1050 - 表'广告'已经存在
查询:CREATE TABLE广告(id bigint(20)NOT NULL auto_increment,city_id int(11)NOT NULL,type text collate utf8_bin NOT NULL,town text collate utf8_bin NOT NULL,address text collate utf8_bin NOT NULL,price text collate utf8_bin NOT NULL,info text collate utf8_bin NOT NULL,链接文本collate utf8_bin NOT NULL,hasImage int(11)NOT NULL,language varchar(2)collate utf8_bin NOT NULL,time_added varchar(255)collate utf8_bin NOT NULL,PRIMARY KEY(id)) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin AUTO_INCREMENT = 1
错误发生在:2009-09-08 17:42:07行号:35错误代码:1050 - 表'广告'已经存在
查询:1斯坦福大学6700 http://www.orkut.co.in . . .