How to export data from a specified table in MySQL

This article mainly introduces relevant information about the detailed explanation of MySQL exporting data in the specified table. I hope this article can help everyone. Friends in need can refer to

Detailed explanation of MySQL export specification Data in the table

Requirements:

1. Do not export the table creation statement because the table has already been created: the default is To export, first drop table and then create table;
2. Add ignore to the exported insert statement, allowing repeated execution: ignore will not be added by default;
3. List the fields in the table in the insert statement, see More clearly: not by default;
4. Multiple insert statements are generated for each record, which is easier to modify: the default is one;

The final result is as follows:

mysqldump -pxxxxxx qzt qf1_mail_account --no-create-info --insert-ignore --complete-insert --skip-extended-insert >qf1_mail_account.sql

Among them:

-pxxxxxx Specify password
qzt database name
qf1_mail_account table name
>qf1_mail_account.sql Save to file

mysqldump --help wrote

 -t, --no-create-info 
           Don't write table creation info.
 --insert-ignore   Insert rows with INSERT IGNORE.
 -c, --complete-insert 
           Use complete insert statements.
 -e, --extended-insert 
           Use multiple-row INSERT syntax that include several
           VALUES lists.
           (Defaults to on; use --skip-extended-insert to disable.)

The above is the detailed content of How to export data from a specified table in MySQL. For more information, please follow other related articles on the PHP Chinese website!