Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > Sql中如何同时更新多个表的数据

Sql中如何同时更新多个表的数据

WBOY
Release： 2016-06-23 13:49:45
Original
1695 people have browsed it

请举例说明这样的例子。谢谢


回复讨论(解决方案)

一个一个 update 就是了

如果一个数据的改动就需要操控多个表的话，显然是你的表设计是有问题的

表关联（Join）、  触发器 、事务、update  表1,表2..
可以去百度一下，哪个不懂再问

Related labels：
sql Multiple data renew
source：php.cn
Previous article：这种只有科学家才懂的话,到底是啥意思哈 Next article：表关联获取7最新的7条数据变成了1条
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
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Move the content to the left by adding the Width property I have provided margins to the body. main {left margin: 200px; right margin: 200px; text a...
From 2024-04-06 22:01:35
0
3
816
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
Regular expression to match words I have a script where I am trying to match new job names with existing job names in a data...
From 2024-04-06 21:24:04
0
1
606
The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
From 2024-04-06 21:23:40
0
2
530
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