Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > mysql两张表关联设置里面的内容

mysql两张表关联设置里面的内容

WBOY
Release： 2016-06-06 09:40:14
Original
870 people have browsed it

mysqlsql

已经第一张表goods 主键goods_id，价格price，另一张表product 有外键goods_id，价格price。现在要求如果product中的price=0，那么设置这个price的值等于goods表中的price，求这条sql怎么写，谢谢大家

Related labels：
mysql sql
source：php.cn
Previous article：mysql中的字符串匹配的原理是什么 Next article：c++ ado访问mysql存储过程 怎么解
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
2311
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
2446
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
2062
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
1949
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
2012
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