Detailed explanation of the example of exporting data from a specified table in MySQL

Detailed explanation of MySQL exporting data from a specified table

Require:

1. Do not export the statements for creating a table, because the table has already been created: by default, it will be exported, first drop table and then create table;
2. Add ignore to the exported insert statement to allow repeated execution: ignore is not added by default;
3. List the fields in the table in the insert statement to see more clearly: No by default;
4. Generate multiple insert statements 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

in:

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

mysqldump --help says

 -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.)

If you have any questions, please leave a message or come to the community to discuss. Thank you for reading and I hope it can help you. Thank you for your support of this site!