1. The field: permission in the table: weibo_weibo_connect_web_app_user is to be migrated to the field: permission in the table: channel_app_source, and then the field: permission in the table: weibo_weibo_connect_web_app_user will be deleted, as shown in Figure 1
2. The field: permission in the table: channel_app_source. The field: channel_app_source_id in the table: weibo_weibo_connect_web_app_user is associated with the field: id in the table: channel_app_source, as shown in Figure 2
3. The SQL is as follows. It updates the value of the field: permission in the table: channel_app_source to the value of the field: permission in the table: weibo_weibo_connect_web_app_user, with the condition: (the value of the field: id in the table: channel_app_source equals the value of the field: channel_app_source_id in the table: weibo_weibo_connect_web_app_user). 1 row was affected, as shown in Figure 3. Viewing the update result, the value of the field: permission in the table: channel_app_source has been updated to: 2, as shown in Figure 4
UPDATE `cpa_channel_app_source`, `cpa_weibo_weibo_connect_web_app_user` SET `cpa_channel_app_source`.`permission` = `cpa_weibo_weibo_connect_web_app_user`.`permission` WHERE `cpa_channel_app_source`.`id` = `cpa_weibo_weibo_connect_web_app_user`.`channel_app_source_id`;