mysql - MySQL 和 SQL 的 .sql 文件是否不同？

Question

我有一个 .sql 文件，我想将它加载到 MySQL 数据库中。我不知道它是从哪个数据库(MySQL 或 MS-SQL)创建的。

现在，我正在尝试将该文件导入 MySQL 数据库。它在导入和执行该文件时显示错误。

Q1. So, my question is whether the .sql file generated from MySQL and MS-SQL are different?

注意:我正在使用 SQLYog 软件(MySQL 的图形界面)导入文件。

这是错误:

Query: CREATE TABLE ads ( 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, link text 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 - 表“广告”已存在

Query: CREATE TABLE ads ( 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, link text 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 - 表“广告”已存在

Query: CREATE TABLE ads ( 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, link text 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 - 表“广告”已存在

Query: CREATE TABLE ads ( 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, link text 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 - 表“广告”已存在

Query: 1 Stanford University 6700 http://www.orkut.co.in . . .

Answer 1

文件扩展名“.sql”本质上是没有意义的:它只是为了让您知道该文件是什么。它只是一个包含 SQL 的纯文本文件，您可以在记事本中打开它。因此，没有特殊的“mysql”或“sql server”扩展。

您遇到的错误 “Table 'ads' already exists” 是因为您正在尝试创建一个已存在于数据库中的表。 (你读过错误了吗？)你有几个选择:

1. 将 SQL 改成这样:

   CREATE TABLE IF NOT EXISTS ads ( id bigint(20) ...
   

2. 将 SQL 改成这样:

   DROP TABLE IF EXISTS ads;
   CREATE TABLE ads (id bigint(20) ...
   

3. 首先清除数据库中的所有表。