mysql 接收 output_Mysql之文本导入导出INTO和OUTPUT

直接上例子：

导出：

select * from user_b limit 10

into outfile "c:/data.txt"

FIELDS TERMINATED BY ','

LINES TERMINATED BY '\r\n';

导入：

LOAD DATA INFILE 'c:/data.txt'

[replace] INTO TABLE user

FIELDS TERMINATED BY ','

LINES TERMINATED BY '\r\n';

针对load data参数说明如下：

load data [low_priority] [local] infile 'file_name txt' [replace | ignore]

into table tbl_name

[CHARACTER SET charset_name]

[fields

[terminated by't']

[OPTIONALLY] enclosed by '']

[escaped by'\' ]]

[lines

[STARTING BY 'string']

[terminated by'n']]

[ignore number lines]

[(col_name, )]

low_priority:MySQL将会等到没有其他人读这个表的时候，才把插入数据。可以使用如下的命令：

local:指定lo