Solution for MySQL update with Error Code: 1093 and Error Code: 1175

MySQL update Error Code: 1093 and Error Code: 1175 solution MySQLSQLError Code: 1093. you can't specify target table 'ws _ product' for update in FROM clause, which is caused by the subquery added to the where condition when the update or delete statement is used. For example, the following update statement:

Update table set type = 'state' where id in (select id from ws_product where first_name = 'superman ');

 

Modify the preceding statement as follows to solve the problem:

Update ws_product set type = 'static 'where id in (select id form (select id from ws_product where first_name = 'superman') xx );

 

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 Queries and reconnect. the solution is to execute the following statement in the current session:

SET SQL _SAFE_UPDATES = 0;

 

Then execute the Update statement.