mysql查询或更新单双数字的内容

最新推荐文章于 2023-05-16 08:32:37 发布

iteye_13003

最新推荐文章于 2023-05-16 08:32:37 发布

阅读量322

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql database 文章标签：乔乐共享 odd even update

本文链接：https://blog.youkuaiyun.com/iteye_13003/article/details/82549922

database 同时被 2 个专栏收录

26 篇文章

订阅专栏

mysql

23 篇文章

订阅专栏

本文详细介绍了如何使用SQL查询数据库并更新数据记录，通过具体案例展示了查询与更新操作的实现过程，包括使用MySQL执行查询和更新语句，并对查询结果进行实际修改。

select * from tbl_name where userid%2=1


mysql> select * from message_bak;
+----+-----------+--------------------+---------------------+
| id | name      | content            | time                |
+----+-----------+--------------------+---------------------+
|  1 | weirui    |  xiaozhuqushangban | 2013-11-13 17:10:05 |
|  2 | lemontree |  xiaozhuqushangban | 2013-11-15 13:47:10 |
|  3 | weirui    |  xiaozhuqushangban | 2013-11-16 14:38:42 |
|  4 | weirui    |  xiaozhuqushangban | 2013-11-11 11:11:11 |
|  5 | weirui    |  xiaozhuqushangban | 2013-11-18 17:47:03 |
|  6 | weirui    |  xiaozhuqushangban | 2013-11-19 10:17:17 |
|  7 | weirui    |  xiaozhuqushangban | 2014-11-11 11:11:13 |
|  8 | weirui    |  xiaozhuqushangban | 2013-11-19 10:17:17 |
|  9 | lemontree |  xiaozhuqushangban | 2013-11-19 10:17:17 |
+----+-----------+--------------------+---------------------+
9 rows in set (0.00 sec)

mysql> update message_bak set content ='xiaoxiongquxiaban' where id%2 = 1;
Query OK, 5 rows affected (0.02 sec)
Rows matched: 5  Changed: 5  Warnings: 0