mysql中执行sql语句时出错 - MS-SQL Server / 基础类

在 MySQL中执行如下语句

delete t from (select top 2 * from use_table) t

时出错：


SQL 执行错误#1064.从数据库的响应：

You hava an error in your SQL syntax ; check the manual that corresponds to your MySQL server for the right

syntax to use near '2 * from use_table) t' at line 1

---

SQL code:
mysql 里面可以这样写么？？不懂，帮顶...
delete t from (select top 2 * from use_table) t

---

delete t from t where 关键字 in (select top 2 关键字 from use_table)

---

引用

在 MySQL中执行如下语句

delete t from (select top 2 * from use_table) t

时出错：


SQL 执行错误#1064.从数据库的响应：

You hava an error in your SQL syntax ; check the manual that corresponds to your MySQL server f……

我的mysql-5.0.22-win32里试了，没有这个语法

---

SQL code:
delete from 表名 where 条件 in (select top 2 条件 from 表名 )

---

code=SQL]delete from use_table limit 2;[[/code]
{{