mysql -uroot -p -DAllCode -e "LOAD DATA LOCAL INFILE '/root/data/CODE.txt' INTO TABLE code (id,code1,code2,@ttime,code3) set time=FROM_UNIXTIME(@ttime/1000)"
数据格式为
23057 156678 1A7DD 1479809538482 8878
mysql -uroot -p -DAllCode -e "LOAD DATA LOCAL INFILE '/root/data/CODE.txt' INTO TABLE code (id,code1,code2,@ttime,code3) set time=FROM_UNIXTIME(@ttime/1000)"
数据格式为
23057 156678 1A7DD 1479809538482 8878
本文标题:mysql load data local infile uni
本文链接:https://www.haomeiwen.com/subject/suswkftx.html
网友评论