LOAD DATA
INFILE 'dat.txt'
APPEND INTO TABLE emp FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY ’"’
(empno, ename, job, mgr,hiredate DATE "yyyy年-mm月-dd日hh24:mi:ss",sal,comm)
INFILE 'dat.txt'
APPEND INTO TABLE emp FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY ’"’
(empno, ename, job, mgr,hiredate DATE "yyyy年-mm月-dd日hh24:mi:ss",sal,comm)
怎么会不对
LOAD DATA
INFILE 'e:\dat.txt'
APPEND INTO TABLE test FIELDS TERMINATED BY ","
(id,stime timestamp "yyyymmddhh24:mi:ss",etime timestamp "yyyymmddhh24:mi:ss")
infile 'c:/test.csv'
APPEND into table test
fields terminated by ','OPTIONALLY ENCLOSED BY '"'
(时间 date "yyyy-mm-dd hh24:mi:ss",
状态
)