How to see errors in MySQL Workbench 6.1?
I recently upgraded my development machine to use MySQL Workbench 6.1. I am trying to enter some data into a table using the workbench and "Select rows..." When I click the "Apply" button to insert the data, the workbench reports that an error occurred (see the image below), but it doesn't tell me what the error is. Workbench 5.* used to show the errors. I cannot find any way to get Workbench 6.1 to show me the errors. How can I see the error messages?
Solution
To cause MySQL Workbench to show error messages, I had to change a preference. From the Workbench menu, click "Edit" -> "Preferences..." Open the "SQL Queries" tab. Check "Confirm Data Changes".
- How to generate the whole database script in MySQL Workbench?
- How can I have MySQL Workbench autocomplete with uppercase?
- MySQL Workbench - Altering Next Auto Increment Value does not Work
- Adding new column via MySQL Workbench into existing table
- How can I style MySQL Workbench
- Can't update theme on MySQL Workbench for Mac
- How to disable dark theme for MySQL Workbench
- How do I go from a MySQLWorkbench EER model (ERD) to Django?
- Adding foreign key to existing table gives error 1050 table already exists
- Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?
- Is there a simple way to get SQL Workbench to only focus on one database?
- How to connect MySQL Server to Workbench
- mysql could not connect the SSH tunnel -> access denied for 'none'
- Get prepared statements list in mysql
- How can I import data into mysql database via mysql workbench?
- Query to fetch records having combination of integer and string
- How to see errors in MySQL Workbench 6.1?
- MySQL Workbench 8.0 - show errors?
- MySQL Workbench crash when Starting/Stopping Server
- mysql workbench 8.0.36 does not work under osx14
- file conversion- .mwb to .sql file
- MySQL Workbench auto increment disabled
- How can I add SRID 4326 (Spatial Types) to Workbench when adding columns?
- MySQL Workbench not showing Apply and Revert buttons while creating a table
- MySQL workbench table data import wizard extremely slow
- How to make a field NULL using MySQL GUI Tools?
- Importing CSV using MySQL Workbench. Not all records imported
- SQL SELECT query not working in mysql
- A column in a table is referred to by multiple physical column names
- How can I find the longest number of consecutive nulls in a column in MySQL?