1. Description of the problem
Through the graphical tool, the Query window with the SELECT statement by criteria to query the desired results, and then use the "Export Wizard" to guide the query results into SQL file, but the resulting SQL statement is not complete, no table name, field name.
Through the graphical tools, tried a lot of times, and then used the mysqldump
2. Export the Insert SQL script file via mysqldump
# MySQL export insert with field SQL script data # mysqldump-u user name-p password-H database host ip-p port number--skip-extended-insert--complete-insert database name Table name -t-c--where= "condition" >~/ Test.sql --skip-extended-Inserts a row of exports -t does not produce the CREATE TABLE and drop TABLE statements -C produces a complete INSERT statement (area characters wrongly written) --where stitching condition, only data that matches the criteria are exported
3.MySQLdump parameter details, reference:
# mysqldump--help
mysqldump Exporting SQL scripts