更新时间:2023-09-04 18:47:22
每次你尝试更新mysql中的行时遇到这种错误,那是因为你尝试更新一个没有使用的WHERE的表KEY
列.
Every time you encountered that kind of error when trying to update rows in mysql, It’s because you tried to update a table without a WHERE that uses a KEY
column.
你可以修复它,
SET SQL_SAFE_UPDATES=0;
UPDATE user SET email = 'abc@yahoo.com' WHERE email='ripon.wasim@yahoo.com';
或在工作台中