Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 哪位大侠能够一条sql语句执行更新多条记录,该如何解决

哪位大侠能够一条sql语句执行更新多条记录,该如何解决

WBOY
Release： 2016-06-13 13:42:59
Original
739 people have browsed it

哪位大侠能够一条sql语句执行更新多条记录
id num
1 1
2 2
3 4
4 8


表名test

最终结果
id为1的， 更新为2
id为2的，更新为3
id为3的，更新为6
id为4的，更新为11



------解决方案--------------------
如果不是相同的是无法一起更新的.看看有没其他神奇的写法吧

Related labels：
sql test
source：php.cn
Previous article： 在这基础上加入分页和添加,该怎么解决 Next article： discuz语法有关问题
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
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1429
Display an element after a block newline I currently have this: I want to put the icon div at the end of the text, but since it's a...
From 2024-04-04 21:45:21
0
1
271
CSS: Modify spacing between list items I tried editing the CSS of the list but I didn't find how to correctly go to the rows and ...
From 2024-04-02 15:46:38
0
1
342
Create a basic PHP login system: a step-by-step guide I have a task to make a login system using php, specifically one that hashes passwords int...
From 2024-04-02 11:54:37
0
1
412
Using regex to replace HTML in div and add spacing Hi, I would like help creating a regex that replaces all html tags, but when the end div a...
From 2024-04-02 11:28:02
0
1
420
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