How To Export MySQL Data as Insert Statements

来源:互联网 发布:淘宝 微博 编辑:程序博客网 时间:2024/06/05 07:46

1. Tool

Toad for MySQL, free software

2. Solution A

Toad's default behavior is exporting the whole table, thus we'd better create a temporary table first, insert the query result, and follow the Export Wizard, beware choose the SQL Script option.

3. Solution B



0 0