MySQL Forums
Forum List  »  MySQL Workbench

Export query results for insert : missing table
Posted by: Olivier VARROT
Date: October 14, 2020 06:20AM

Hello I'm using Mysql Workbench 8.0.19 CE

When I export a result of a Select Query using the button "Exports recordset to an external file", I choose the folder, the type "SQL INSERT statements (*.sql)", I click on "Save" button, the software prompt me to enter the name of the table (for example : "testtable") and I click "Ok".
But when I edit the Sql file, I don't have the table name after the word "INTO" :

INSERT INTO `` (`CODE,`LIBELLE' ...
INSERT INTO `` (`CODE,`LIBELLE' ...
INSERT INTO `` (`CODE,`LIBELLE' ...

Do I make an error or it's a bug ?

Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
Export query results for insert : missing table
72
October 14, 2020 06:20AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.