MySQL exports data from a specified table

MySQL: 1. do not export the statement for table creation, because the table has been created: exported by default, drop table first and then create table; 2. add ignore to the exported insert statement to allow repeated execution: ignore is not added by default; 3. the insert statement lists the fields in the table. You can see more clearly: No by default; www.2cto.com 4. multiple insert statements are generated based on different records, which are easy to modify: The default value is one. The final result is mysqldump-pxxxxxx qzt into mail_account -- no-create-info -- insert-ignore.
-- Complete-insert -- skip-extended-insert> begin into mail_account. SQL
Where:-pxxxxxx specifies the password qzt database name too many mail_account table Name> too many mail_account. SQL save to the file www.2cto.com mysqldump -- help writes-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 .) author: codingstandards