LOAD DATA INFILE 'D:/Temp/fileToImport.csv'
INTO TABLE db.mytable
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
(@abcde, @aaa, @RNs, @country, @status)
SET abcde=@abcde, aaa=@aaa, RNs = @RNs, country=@country
Mysql Load Data Infile
最新推荐文章于 2024-08-02 17:49:19 发布