Error message:
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.
Solution:
add before the update (/delete) statement:
SET SQL_SAFE_UPDATES=0;
The copy-pastes and explanations blog for SQL code, errors and daily cases! This blog is a 'list' of actions that always good to have available. The copy-paste concept here is short and clear explanations and descriptions (no long stories!) and - of course - the code to take (copy) and use (paste). The blog deals in the database (mostly) and software issues.
Error message:
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.
Solution:
add before the update (/delete) statement:
SET SQL_SAFE_UPDATES=0;
No comments:
Post a Comment