Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to export the data in the specified table in MySQL, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

MySQL exports data in the specified table

Request:

1. Do not export the statement that creates the table, because the table has been built: it will be exported by default, first drop table and then create table

two。 The exported insert statement plus ignore allows repeated execution: ignore is not added by default

3. List the fields in the table in the insert statement to see more clearly: not by default; www.2cto.com

4. Separate records to generate multiple insert statements, which is relatively easy to modify: the default is one

The final results are as follows:

Mysqldump-pxxxxxx qzt qf1_mail_account-no-create-info-insert-ignore

-- complete-insert-- skip-extended-insert > qf1_mail_account.sql

Where:

-pxxxxxx specifies the password

Qzt name

Qf1_mail_account table name

Saving qf1_mail_account.sql to file

Www.2cto.com

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

After reading the above, do you have any further understanding of how to export the data in the specified table in MySQL? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.