MySQL Forums
Forum List  »  MySQL Workbench

Re: Export multiple results sets as insert statements
Posted by: Jagdip Ajimal
Date: July 17, 2020 02:12AM

Here's an example:

You have the following select statements:

select * from orders where user_id = 20;
select * from users where user_id = 20;
select * from addresses where user_id = 20;

When you execute this script, you get 3 tabs - one for each select statement.

To export the statement as SQL Insert Statements, you need to go to each tab, click on the Export/Import icon and save the file.

My problem is that I have ~30 of these statements that need to be exported as SQL Insert Statements. Going through each tab is slow, and I can easily miss one tab. So I would like something that will let me export the SQL Insert Statements for all the result tabs.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Export multiple results sets as insert statements
28
July 17, 2020 02:12AM


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.