今天在mysql下面练一下SQL语句,写到一句 update set sex="female" where age=22时,报错了
错误: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.
中文直译应该也看得懂,就是说在安全模式下做更新操作时必须要使用where且带主键,或者去偏好设置里面关闭该模式。
今日mark一下,以供后来查看