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
591
October 14, 2020 06:20AM


Sorry, you can't reply to this topic. It has been closed.

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.