MySQL Import and export

Http://www.cnblogs.com/wyzs/p/6762452.html

MySQL data import and export this way can quickly realize the fast import and export of millions level data.

(Operation only on server, operation fails when file exists)

• Export to file (SELECT INTO outfile)

1234567891011

SELECT fields INTO OUTFILE ‘file_name‘    [{FIELDS | COLUMNS}                        字段        [TERMINATED BY ‘string‘]               字段之间分隔符号        [[OPTIONALLY] ENCLOSED BY ‘char‘]       字段被包含在char中间        [ESCAPED BY ‘char‘]                  忽略字段里出现的char    ]    [LINES        [STARTING BY ‘string‘]                 忽略开头是string的行        [TERMINATED BY ‘string‘]            行分隔符    ]FROM test_table;

• Import data from a file to a MySQL table

1234567891011121314151617

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE ‘file_name‘    [REPLACE | IGNORE]                     遇到重复的时候处理方法，替换|忽略    INTO TABLE tbl_name                    导入数据的目的表名    [PARTITION (partition_name,...)]            分区选择    [CHARACTER SET charset_name]           　　字符集    [{FIELDS | COLUMNS}               　　　　字段        [TERMINATED BY ‘string‘]           字段之间分隔符号        [[OPTIONALLY] ENCLOSED BY ‘char‘]     字段被包含在char中间        [ESCAPED BY ‘char‘]              忽略字段里出现的char    ]    [LINES        [STARTING BY ‘string‘]             忽略开头是string的行        [TERMINATED BY ‘string‘]           行分隔符    ]    [IGNORE number {LINES | ROWS}]          忽略行/列    [(col_name_or_user_var,...)]              目的表的表字段名或者用户变量名    [SET col_name = expr,...]                设置表字段值

MySQL Import and export