mysql中操作txt文档,将数据添加到表中
1.开发文档基本语法
load data [low_priority] [local] infile 'file_name txt' [replace | ignore]
into table tbl_name
[fields
[terminated by't']
[OPTIONALLY] enclosed by '']
[escaped by'\' ]]
[lines terminated by'n']
[ignore number lines]
[(col_name, )]
注意:oad data infile语句从一个文本文件中以很高的速度读入一个表中。使用这个命令之前,mysqld进程ÿ