Migrate a column of data in the A table in the MySQL database to a column of data in the B table, based on the implementation of a SQL

1. Table: weibo_weibo_connect_web_app_user field: permission, ready to move to table: channel_app_source field in: Permission, and then delete the table: weibo_weibo_connect_web_app_user field: Permission, as shown in Figure 1

Figure 1

2. Table: Fields in channel_app_source: Permission, table: weibo_weibo_connect_web_app_user: CHANNEL_APP_SOURCE_ID Associated with the field: ID in CHANNEL_APP_SOURCE, as shown in Figure 2

Figure 2

3. SQL is as follows, update the table: fields in channel_app_source: the value of Permission is the table: weibo_weibo_connect_web_app_user: Permission The value of the value is: (table: field in channel_app_source: The value of the ID is equal to the table: weibo_weibo_connect_web_app_user Fields in: channel_app_source_id), which affects 1 row, as shown in Figure 3. Check the update results, table: CHANNEL_APP_SOURCE: The value of Permission has been updated to: 2, as shown in Figure 4

Figure 3

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`;