What to do if workbench error is reported in mysql

The solution to the workbench error in mysql: first open and find the workbench; then enter "SET SQL_SAFE_UPDATES = 0;" inside.

Solution to workbench error in mysql:

1. Quick setting, directly in the query window in workbench Just enter "SET SQL_SAFE_UPDATES = 0;". If you want a graphical interface for setup, please continue.

2. Click "edit-->Preferences" in the workbench menu bar, and then the dialog box "workbench preferences" will pop up

3. Click "SQL Editor" in the left column of "workbench", and you will see that the last line is "Safe Updates..." which is checked. We only need to uncheck it.

#4. After unchecking the box, click the "OK" button. In the Linux system, the "OK" button may not be clickable. Please click "General" in the left column. Editors" option so you can click the "OK" button.

The above is the detailed content of What to do if workbench error is reported in mysql. For more information, please follow other related articles on the PHP Chinese website!