数据库系统概论;
在使用修改update语句时,出现,
0 | 255 | 16:49:10 | update student set 性别='男' where 学号='5033418113' | 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 |
使用 set sql_safe_updates=0; 执行完后在执行update语句。