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?