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]
{{