UPDATE user
u,(SELECT uid,duration FROM user_button_click WHERE button_name=‘loadingScene’ GROUP BY uid) ug SET u.duration=ug.duration
WHERE u.uid =ug.uid
mysql 一个表中的字段同步到另一个表中
最新推荐文章于 2024-03-28 17:57:30 发布
UPDATE user
u,(SELECT uid,duration FROM user_button_click WHERE button_name=‘loadingScene’ GROUP BY uid) ug SET u.duration=ug.duration
WHERE u.uid =ug.uid