Monday, March 24, 2014

MySQL error code: 1175 during UPDATE in MySQL Workbench

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