更新时间:2023-09-04 18:47:40
每次尝试更新mysql中的行时都遇到这种错误,这是因为您尝试更新的表没有使用KEY
的WHERE列.
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';
或在工作台中