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