Home > Database > Mysql Tutorial > body text

MySQL导出指定表中的数据_MySQL

WBOY
Release: 2016-06-01 13:42:30
Original
1040 people have browsed it

bitsCN.com MySQL导出指定表中的数据 要求:1. 不导出创表的语句,因为表已经建好:默认会导出,先drop table然后create table;2. 导出的insert语句加上ignore,允许重复执行:默认不会加上ignore;3. insert语句中列出表中的字段,看得更清楚:默认不会;    4. 分记录生成多条insert语句,修改起来比较容易:默认是一条; 最终结果如下:mysqldump -pxxxxxx qzt qf1_mail_account --no-create-info --insert-ignore
--complete-insert --skip-extended-insert >qf1_mail_account.sql
 其中:-pxxxxxx 指定密码qzt 数据库名qf1_mail_account 表名>qf1_mail_account.sql 保存到文件     mysqldump --help 写道  -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.)  作者 codingstandards bitsCN.com

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template