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?
asked Jun 6, 2014 at 17:14
If you are on linux machine this solution will work. It is already there you have to move your mouse and expand it: At first it will look like this:
you have to hover the mouse until the cursor icon change to resize icon.upward
then click it and pull
and then you can hover on cross sign scroll right to see the error message completely.
answered Jan 2, 2020 at 13:32
4
I eventually worked out that the panel could be opened by hovering my mouse at just the top of the status bar [at the bottom of the UI].
The hit area is tiny so you really have to 'feel' around for the drag point.
answered Mar 14, 2019 at 0:51
Brett SuttonBrett Sutton
2,9692 gold badges20 silver badges41 bronze badges
2
If you are not seeing any sql errors or exceptions this could be one off your problems. Toggle the button in the picture button panel of mysqlworkbench
answered Sep 18, 2019 at 10:16
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".
answered Jun 6, 2014 at 22:00
BarzeeBarzee
8362 gold badges14 silver badges28 bronze badges
1
6.5.1 Table Data Export and Import Wizard
This wizard supports import and export operations using CSV and JSON files, and includes several configuration options [separators, column selection, encoding selection, and more]. The wizard can be performed against local or remotely connected MySQL servers, and the import action includes table, column, and type mapping.
Note
This wizard only exports/imports tables using the JSON or CSV format. For an overview of the data export and import options in MySQL Workbench, see Section 6.5, “Data Export and Import”.
The wizard is accessible from the object browser's context menu by right-clicking on a table and choose either or , as the next figure shows.
Figure 6.11 Table Data Wizards: Open
Table Data Export Wizard
Export table data to either a JSON or CSV file. The following figures show an example of an export sequence of the sakila.actor table to a CSV file.
Figure 6.12 Table Data Export: Source
Figure 6.13 Table Data Export: CSV Configuration
Figure 6.14 Table Data Export: Results
Table Data Import Wizard
You can import table data from either a JSON or CSV file. The following figures show an example of an import sequence of the sakila.actor table from a CSV file.
Figure 6.15 Table Data Import: CSV Source
Figure 6.16 Table Data Import: Destination Table
Figure 6.17 Table Data Import: CSV Configuration
Note
The Encoding field should correspond with your CSV file.
Figure 6.18 Table Data Import: Results