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'); |
|
