MySQL update times wrong you is using Safe update mode

When using MySQL to perform an update, if you do not use the primary key when the where statement, the following error is reported, using the primary key for the where statement is normal.

UpdateTest.t_bidsSetproduct_id=1+ Floor(Rand()*7) Error Code:1175. You is using safeUpdateMode andYou tried to UpdateATablewithout aWHEREthat uses aKEY column  toDisable Safe Mode, toggle theoption inchPreferences -SQL Editor andReconnect.0.000Sec

This is because MySQL runs in safe-updates mode, which causes the update or delete command to not be executed under a non-primary key condition.

Execute command Set sql_safe_updates = 0; Modify the database schema

If you want to increase the database security level, you can restore the original settings and execute the command:

SET = 1;

MySQL update times wrong you is using Safe update mode