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

user9504791

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?

Dave Stokes-MySQL Community Team-Oracle

Are you trying to pull data out of one table and into another? If so have you tried INSERT INTO ... SELECT? https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-select-into-table.html

dvohra21

May select from multiple tables but insert into one table only.

https://dev.mysql.com/doc/refman/5.7/en/insert-select.html