This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,096 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

Its possible to export select sql's output in insert statement

user9504791
user9504791 Member Posts: 1 Green Ribbon

Hello Guys,

I know we can export the select data to CSV like in this post https://thedbadmin.com/mysql-query-output-to-csv/ they have explained but my question is from MySQL prompt can we run select and export the results in insert format to refresh non prod tables?

Tagged:

Answers