Bug #112376 MySQL Workbench "Export Recordset to an External File" Bug
Submitted: 18 Sep 2023 20:13 Modified: 19 Sep 2023 11:40
Reporter: David Reger Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.32 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[18 Sep 2023 20:13] David Reger 
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\dreger\AppData\Roaming\MySQL\Workbench\log\wb.log]

Running a SELECT Query and then choosing Export Recordset to an External File doesn't include table name of query if the exported file type is SQL INSERT Statements.

How to repeat:
Run a SELECT Query, it doesn't matter what query or from what table.
Once your result set appears in the Result Grid, select the option for "Export Recordset to an External File"

In the Save As Dialog that opens, make sure to choose"SQL INSERT Statements" as the file type. Save the export wherever you want.

Open the exported file and at the very top, it'll show your SELECT Query with the table name, but if you go to the portion of the export that contains your actual data, the INSERT Queries leave the table name blank.
[18 Sep 2023 20:42] David Reger 
I forgot to mention on my initial ticket creation that in the 2nd popup dialog where it asks to set a table name, I have a table name populated.
[19 Sep 2023 11:40] MySQL Verification Team 
Hello David,

Thank you for the bug report.
Imho this is duplicate of Bug #95275, please see Bug #95275.

Regards,
Ashwini Patil