||
语法:
DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count]
UPDATE [LOW_PRIORITY] [IGNORE] table_reference
SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ...
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count]
例子:
mysql> select * from kider;
+----+--------------------------------------+
| id | v_str |
+----+--------------------------------------+
| 1 | 5317c160-9daa-11de-ba34-00188be50907 |
| 2 | 574bc150-9daa-11de-ba34-00188be50907 |
| 3 | 5d22a0b2-9daa-11de-ba34-00188be50907 |
| 4 | 5d22a2ec-9daa-11de-ba34-00188be50907 |
| 5 | 607bff06-9daa-11de-ba34-00188be50907 |
| 6 | 607c00fa-9daa-11de-ba34-00188be50907 |
| 7 | 607c0154-9daa-11de-ba34-00188be50907 |
| 8 | 607c0190-9daa-11de-ba34-00188be50907 |
+----+--------------------------------------+
8 rows in set (0.00 sec)
mysql> delete from kider limit 2;
Query OK, 2 rows affected (0.00 sec)
mysql> select * from kider;
+----+--------------------------------------+
| id | v_str |
+----+--------------------------------------+
| 3 | 5d22a0b2-9daa-11de-ba34-00188be50907 |
| 4 | 5d22a2ec-9daa-11de-ba34-00188be50907 |
| 5 | 607bff06-9daa-11de-ba34-00188be50907 |
| 6 | 607c00fa-9daa-11de-ba34-00188be50907 |
| 7 | 607c0154-9daa-11de-ba34-00188be50907 |
| 8 | 607c0190-9daa-11de-ba34-00188be50907 |
+----+--------------------------------------+
6 rows in set (0.01 sec)
mysql> delete from kider order by id limit 2;
Query OK, 2 rows affected (0.01 sec)
mysql> select * from kider;
+----+--------------------------------------+
| id | v_str |
+----+--------------------------------------+
| 5 | 607bff06-9daa-11de-ba34-00188be50907 |
| 6 | 607c00fa-9daa-11de-ba34-00188be50907 |
| 7 | 607c0154-9daa-11de-ba34-00188be50907 |
| 8 | 607c0190-9daa-11de-ba34-00188be50907 |
+----+--------------------------------------+
4 rows in set (0.00 sec)
mysql> select * from kider;
+----+--------------------------------------+
| id | v_str |
+----+--------------------------------------+
| 5 | 607bff06-9daa-11de-ba34-00188be50907 |
| 6 | 607c00fa-9daa-11de-ba34-00188be50907 |
| 7 | 607c0154-9daa-11de-ba34-00188be50907 |
| 8 | 607c0190-9daa-11de-ba34-00188be50907 |
+----+--------------------------------------+
4 rows in set (0.00 sec)
mysql> update kider set v_str= concat( v_str,' + update') order by id limit 2;
Query OK, 2 rows affected (0.01 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> select * from kider;
+----+-----------------------------------------------+
| id | v_str |
+----+-----------------------------------------------+
| 5 | 607bff06-9daa-11de-ba34-00188be50907 + update |
| 6 | 607c00fa-9daa-11de-ba34-00188be50907 + update |
| 7 | 607c0154-9daa-11de-ba34-00188be50907 |
| 8 | 607c0190-9daa-11de-ba34-00188be50907 |
+----+-----------------------------------------------+
4 rows in set (0.00 sec)
mysql> update kider set v_str= concat( v_str,' + update') limit 2;
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> select * from kider;
+----+--------------------------------------------------------+
| id | v_str |
+----+--------------------------------------------------------+
| 5 | 607bff06-9daa-11de-ba34-00188be50907 + update + update |
| 6 | 607c00fa-9daa-11de-ba34-00188be50907 + update + update |
| 7 | 607c0154-9daa-11de-ba34-00188be50907 |
| 8 | 607c0190-9daa-11de-ba34-00188be50907 |
+----+--------------------------------------------------------+
4 rows in set (0.00 sec)
|申请友链|小黑屋|Archiver|手机版|MySQL社区
( 京ICP备07012489号 )
联系人:周生; 联系电话:13911732319
GMT+8, 2024-5-3 16:58 , Processed in 0.042455 second(s), 20 queries , Gzip On.
Powered by Discuz! X3.2
© 2001-2013 Comsenz Inc.