56,803
社区成员




mysql> select * from t1;
+------+------+
| id | f1 |
+------+------+
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
+------+------+
4 rows in set (0.00 sec)
mysql> delete from t1
-> where t1.id >3;
Query OK, 1 row affected (0.09 sec)
mysql> select * from t1;
+------+------+
| id | f1 |
+------+------+
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
+------+------+
3 rows in set (0.00 sec)
mysql>