MySQL DML操作--------CURD最佳实战
mysql> select * from users;+----+-------+-----+-----+
| id | name| sex | age |
+----+-------+-----+-----+
|1 | lisea | F |33 |
|2 | jak | F |33 |
|3 | sea | M |26 |
|4 | hai | F |18 |
|5 | test1 | F |23 |
|6 | test2 | M |34 |
|7 | user1 | F |23 |
|8 | user2 | M |34 |
+----+-------+-----+-----+
8 rows in set (0.00 sec)
mysql> DELETE FROM users WHERE id = 1;
Query OK, 1 row affected (0.02 sec)
mysql> select * from users;
+----+-------+-----+-----+
| id | name| sex | age |
+----+-------+-----+-----+
|2 | jak | F |33 |
|3 | sea | M |26 |
|4 | hai | F |18 |
|5 | test1 | F |23 |
|6 | test2 | M |34 |
|7 | user1 | F |23 |
|8 | user2 | M |34 |
+----+-------+-----+-----+
7 rows in set (0.00 sec)
mysql> DELETE FROM users WHERE id in (2, 4);
Query OK, 2 rows affected (0.01 sec)
mysql> select * from users;
+----+-------+-----+-----+
| id | name| sex | age |
+----+-------+-----+-----+
|3 | sea | M |26 |
|5 | test1 | F |23 |
|6 | test2 | M |34 |
|7 | user1 | F |23 |
|8 | user2 | M |34 |
+----+-------+-----+-----+
5 rows in set (0.00 sec)
mysql> DELETE FROM users WHERE id >= 7;
Query OK, 2 rows affected (0.01 sec)
mysql> select * from users;
+----+-------+-----+-----+
| id | name| sex | age |
+----+-------+-----+-----+
|3 | sea | M |26 |
|5 | test1 | F |23 |
|6 | test2 | M |34 |
+----+-------+-----+-----+
3 rows in set (0.00 sec)
页:
[1]