mysql load data 日期_【mysql load data infile导入文件中含有日期字段的问题】-MySQL论坛-ZOL中关村在线...

表结构:

create table EMC_MONITOR(ENAME varchar(30), SNAPTIME datetime, SPTYPE varchar(10), IOPS decimal(12, 2), THROUGHPUT decimal(12, 2));

文件本件格式:

CX960A,03/03/2009 21:13:39,SP A,1931.377049,15.088883

CX960A,03/03/2009 21:14:38,SP A,2210.619470,17.270465

CX960A,03/03/2009 21:15:38,SP A,2474.417841,19.331389

CX960A,03/03/2009 21:16:38,SP A,2730.311475,21.330558

CX960A,03/03/2009 21:17:38,SP A,2991.458020,23.370766

CX960A,03/03/2009 21:18:38,SP A,3272.425693,25.565826

Load data 脚本:

load data infile '/analyse/CX960A/perdata/analyseCX960spA.csv' ignore into table EMC_MONITOR fields terminated by "," enclosed by '';

数据可以成功,但SNAPTIME字段导入错误:

mysql> select * from EMC_MONITOR;

+--------+---------------------+--------+---------+------------+------------+

| ENAME  | SNAPTIME            | SPTYPE | IOPS    | THROUGHPUT | GMT_CREATE |

+--------+---------------------+--------+---------+------------+------------+

| CX960A | 0000-00-00 00:00:00 | SP A   | 1931.38 |      15.09 | NULL       |

+--------+---------------------+--------+---------+------------+------------+

请问该如何导入日期格式的数据?

楼主热贴