d****u 发帖数: 275 | 1 要load一堆数据入mysql,
notice_datetime是 datetime的,start和end是date
我写的script如下,大牛看看哪里有问题?
运行结果是,notice_date没法录入,start和end没有问题
非常感谢!
LOAD DATA LOCAL INFILE 'F:\\2012.csv'
INTO TABLE xx_DB.xx_table
terminated by ',' enclosed by '"' lines terminated by '\n' (
@NOTICE_DATETIME,
@START_DATE,
@END_DATE
)
SET
NOTICE_DATETIME = CAST(@NOTICE_DATETIME AS DATETIME),
START = STR_TO_DATE(@START, '%m/%d/%Y'),
END = STR_TO_DATE(@END, '%m/%d/%Y'); |
|