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-07-19 03:25:50 发布
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