Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 求教mysql批量更新有关问题

求教mysql批量更新有关问题

WBOY
Release： 2016-06-13 13:39:32
Original
808 people have browsed it

求教mysql批量更新问题
我想批量更新数据，字段值也不同
例如：
set s=1 where id=1;
set s=2 where id=3;
这种情况除了逐条更新还有更好的方法吗？
因为一次更新有可能比较多
谢谢


------解决方案--------------------
UPDATE table
SET s = CASE id
WHEN 1 THEN '1'
WHEN 3 THEN '2'
END
WHERE id IN (1,3)

大概这样

Related labels：
id set then where
source：php.cn
Previous article： 关于数据库外键和主键查询的有关问题 Next article： 请问熟悉DiscuzX1.5的大猿~
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Unable to get cookie data from Go server using React After React I started going into the backend and added githubOAUTH and sessions on the bac...
From 2024-04-06 13:09:26
0
1
384
Why does the number of cookies in the "Cookie" request header exceed the number of cookies set in the "set-cookie" response header? I'm a newbie to web crawling, so my understanding of http requests is very shallow. When I...
From 2024-04-05 14:52:06
0
1
3571
Add counted duplicate values ​​in filtred array using ...new Set I have an array with duplicate values ​​which I get from API, the following code uses...ne...
From 2024-04-04 19:03:41
0
1
313
The set*** function is called but the re-rendering of the function component is not executed. My script looks like below, after the api gets the item, I want to re-render the component...
From 2024-04-04 09:53:14
0
1
288
What is the modern equivalent of LESS string-set For an example of string sets and their uses, see Using LESS String Set Properties and Con...
From 2024-04-02 13:29:36
0
1
361
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template