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

续问：求教mysql批量更新有关问题

WBOY
Release： 2016-06-13 13:38:39
Original
863 people have browsed it

续问：求教mysql批量更新问题
UPDATE table
SET s = CASE id
WHEN 1 THEN '1'
WHEN 3 THEN '2'
END
WHERE id IN (1,3)
更新一个字段这样写，要是同时更新两个或者更多字段怎么写

------解决方案--------------------
一样的啊……

update table set field_a='', field_b='',……

你的代码里''部分，被CASE WHEN语法代替了

如果别的字段还是依赖某个字段的，同样的结构代替

Related labels：
case then update
source：php.cn
Previous article： session有关问题 Next article： PHP中$link=mysql_connect("localhost""root""");解决思路
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
3
2043
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2203
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1860
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1746
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1768
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