mysql> SELECT * FROM `tb`;
+----------+
| name |
+----------+
| abctest |
| abc2test |
| abc3test |
+----------+
3 rows in set (0.00 sec)mysql> SELECT @DEL := `name` FROM `tb` LIMIT 1,1;
+----------------+
| @DEL := `name` |
+----------------+
| abc2test |
+----------------+
1 row in set (0.00 sec)mysql> DELETE FROM `tb` WHERE `name` = @DEL;
Query OK, 1 row affected (0.00 sec)mysql> SELECT * FROM `tb`;
+----------+
| name |
+----------+
| abctest |
| abc3test |
+----------+
2 rows in set (0.00 sec)
+----------+
| name |
+----------+
| abctest |
| abc2test |
| abc3test |
+----------+
3 rows in set (0.00 sec)mysql> SELECT @DEL := `name` FROM `tb` LIMIT 1,1;
+----------------+
| @DEL := `name` |
+----------------+
| abc2test |
+----------------+
1 row in set (0.00 sec)mysql> DELETE FROM `tb` WHERE `name` = @DEL;
Query OK, 1 row affected (0.00 sec)mysql> SELECT * FROM `tb`;
+----------+
| name |
+----------+
| abctest |
| abc3test |
+----------+
2 rows in set (0.00 sec)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货