Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

user9504791Sep 18 2021

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?

Comments

Post Details

Added on Sep 18 2021
2 comments
667 views