mysql导入txt

load data local infile '/home/yingqi.jyqi/datax_tb.txt' into table datax_tb fields terminated by ',';

create table datax_tb (c_id int, c_long int, c_double double, c_data timestamp, c_string varchar(128), c_boolean varchar(8), c_byte varchar(256));

drop table datax_tb;

delete from datax_tb;