Forum Stats

  • 3,770,050 Users
  • 2,253,054 Discussions
  • 7,875,283 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