Bug #106613 When I export a result set as insert statements, the table name is missing
Submitted: 1 Mar 2022 19:19 Modified: 2 Mar 2022 6:08
Reporter: Allen Kenney Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.26 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[1 Mar 2022 19:19] Allen Kenney 
Description:
When I export a result set as insert statements, the table name is missing

How to repeat:
1) select * from <some table>
2) Export the result set
3) Select "SQL Insert Statements"
4) I am prompted for "Export options for SQL INSERT statements and I leave the default "Table Name": <some table>
5) When the SQL is generated it is missing the table name. Example:

INSERT INTO `` ...

when it should be:
INSERT INTO `<some table>` ...
[1 Mar 2022 19:20] Allen Kenney 
PS - It would also be nice if the SQL insert statements would generate as batches...it is so much faster to insert a batch of 1000 records than to run 1000 individual insert statements.
[2 Mar 2022 6:08] MySQL Verification Team 
Hello Allen Kenney,

Thank you for the bug report.
This is most likely duplicate of Bug #94179, please see Bug #94179

Regards,
Ashwini Patil