1. I executed the UPDATE statement in MySQL Workbench, the statement is as follows:
SQL
UPDATE `cpa_channel_app_source` SET `group_id` = '015ce30b116ce86058fa6ab4fea4ac63' WHERE (`group_id` = 'spider');
2. An error occurred: Error Code: 1175, the specific error message is as follows:, as shown in Figure 1
SQL
UPDATE `cpa_channel_app_source` SET `group_id` = '015ce30b116ce86058fa6ab4fea4ac63' WHERE (`group_id` = 'spider')
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
3. I executed the UPDATE statement in phpMyAdmin, the statement is as follows: The execution was successful, as shown in Figure 2
SQL
UPDATE `cpa_channel_app_source` SET `group_id` = '015ce30b116ce86058fa6ab4fea4ac63' WHERE (`group_id` = 'spider');
4. According to the prompt, to disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. Uncheck the safe update option, as shown in Figure 3
Plaintext
Safe Updates (rejects UPDATEs and DELETEs with no restrictions)
5. After closing the connection, I reconnected and executed the UPDATE statement, the statement is as follows: The execution was successful, as shown in Figure 4
SQL
UPDATE `cpa_channel_app_source` SET `group_id` = '015ce30b116ce86058fa6ab4fea4ac63' WHERE (`group_id` = 'spider');
Plaintext
UPDATE `cpa_channel_app_source` SET `group_id` = '015ce30b116ce86058fa6ab4fea4ac63' WHERE (`group_id` = 'spider')
1 row(s) affected Rows matched: 1 Changed: 1 Warnings: 0