执行SQL语句时,报错:
13:36:42 delete from users where username='lisi' 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. 0.000 sec
解决方法:
执行SQL语句:
SET SQL_SAFE_UPDATES = 0;
output:
13:40:53 SET SQL_SAFE_UPDATES = 0 0 row(s) affected 0.000 sec