mysql --local-infile -uhoolai -phoolai ExtGameServer -e "LOAD DATA LOCAL INFILE '/root/share/removeCode/betaRebate.csv' INTO TABLE BETAREBATEINFO FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 1 LINES"
LOAD DATA LOCAL INFILE '/root/share/removeCode/betaRebate.csv' INTO TABLE `BETAREBATEINFO` FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES;
show variables like '%secure_file_priv%'
secure_file_priv = '/'
mysql导入csv文件
最新推荐文章于 2024-05-05 18:00:10 发布