问题描述
这是我的一般要求
更新`Antrix` .creature_proto`
设置`health` =（从'antrix2`选择`health` .`creature_proto`其中`entry` =（从'Antrix``creature_proto`中选择条目）;
我有一个名为Antrix的dB和一个名为antrix2
我想使用antrix2.creature_proto中的数据覆盖colums Antrix.creature_proto。（health）中的数据。（健康状况）....
这有效......但是问题是......其中Antrix.entry中的条目不在antrix2.entry中..它将Antrix.health中的数据设置为0。
任何想法如何停止这个？
This is my general quiry
update `Antrix`.`creature_proto`
set `health` = (select `health` from `antrix2`.`creature_proto` where `entry` = (select entry from `Antrix`.`creature_proto`);
I have a dB named Antrix and one named antrix2
I want to overwrite the data in colums Antrix.creature_proto.(health) with the data from antrix2.creature_proto.(health)....
this works... but hte problem is.... where entries in Antrix.entry arent in antrix2.entry.. it sets the data from Antrix.health to 0 on those entries.
Any ideas how to stop this?
推荐答案
这篇关于帮助进行quiry - 更新是否会影响我的现有数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！