Execute the update statement in mysql workbench, and report an error: error code: 1175 analysis solution

1. Execute the update statement in mysql workbench, the statement is as follows:

update `cpa_channel_app_source` set `group_id` =015ce30b116ce86058fa6ab4fea4ac63where (`group_id` =spider);

2. Error code: 1175, the specific error information is as follows:, as shown in Figure 1

Figure 1

update `cpa_channel_app_source` set `group_id` =015ce30b116ce86058fa6ab4fea4ac63where (`group_id` =spider)
Error code: 1175. You are using safe update mode and you tried to update a where that uses a key Column
To disable safe mode, toggle the option in preferences -> SQL editor and reconnect.

3. Execute the update statement in phpmyadmin, the statement is as follows: the execution is successful, as shown in Figure 2

Figure 2

update `cpa_channel_app_source` set `group_id` =015ce30b116ce86058fa6ab4fea4ac63where (`group_id` =spider);

4. According to the prompts, to disable Safe Mode, switch options and reconnect in Preferences – >SQL Editor. Uncheck the security update options, as shown in Figure 3

Figure 3

Safe updates (rejects updates and deletes)

5. After closing the connection, reconnect and execute the update statement, the statement is as follows: the execution is successful, as shown in Figure 4

Figure 4

update `cpa_channel_app_source` set `group_id` =015ce30b116ce86058fa6ab4fea4ac63where (`group_id` =spider);

update `cpa_channel_app_source` set `group_id` =015ce30b116ce86058fa6ab4fea4ac63where (`group_id` =spider)
1 row(s) effected rows matched: 1 changed: 1 warnings: 0