加载数据

加载正常的日期时间

load data infile ‘ftp://gbase:gbase@192.168.0.100//opt/ac08.txt’
into table ac08
NULL_VALUE ‘\N’
fields terminated by ‘,’
ENCLOSED BY ‘"’
DATETIME FORMAT ‘%Y-%m-%d %H:%i:%s’;

加载带毫秒的日期

load data infile ‘ftp://gbase:gbase@192.168.0.100//opt/ac08.txt’
into table ac08
NULL_VALUE ‘\N’
fields terminated by ‘,’ ENCLOSED BY ‘"’
DATETIME FORMAT ‘%Y-%m-%d %H:%i:%s.%f’;