sql更新字段值等于另一张表的值
程序员文章站
2022-05-03 20:21:12
sql更新字段值等于另一张表的值
UPDATE
`user_function_power`
LEFT JOIN `version_buy`
ON user_function...
sql更新字段值等于另一张表的值
UPDATE`user_function_power`
LEFT JOIN `version_buy`
ON user_function_power.`enterprise_id` = version_buy.`enterprise_id`
AND user_function_power.`vcode`=version_buy.`vcode`
SET user_function_power.`endtime` = version_buy.`end_time`