mysql和sql文件_.sql文件与MySQL和SQL有什么不同?

我有一个.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 . . .

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值