mysql: Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

mysql workbench 执行 批量update失败，报错1175

update table_name set column = xxx where id in ( select id from  table_name  where column1= 'xxx')

 

解决：先执行SET SQL_SAFE_UPDATES = 0;

再执行SQL