MySQL删除指定行

mysql> select * from tx;
+------+
| id   |
+------+
|    4 |
|    7 |
|    3 |
|    9 |
|    5 |
+------+
5 rows in set (0.05 sec)

mysql> delete a from tx a inner join (select * from tx limit 2,2) b on a.id=b.id;
Query OK, 2 rows affected (0.11 sec)

mysql> select * from tx;
+------+
| id   |
+------+
|    4 |
|    7 |
|    5 |
+------+
3 rows in set (0.01 sec)