It is look like that MySql run with safe-updates option. It mean you can't update or delete record without key (ex.
primary key
) on where clause.
Try use:
SET SQL_SAFE_UPDATES = 0;
or you can modify your query to follow the rule (use
primary key
on where clause
).
No comments:
Post a Comment