sql script
load data infile "address_200w.csv" into table ethereum_addrs
FIELDS TERMINATED BY ',' #分隔符
ENCLOSED BY '"' #结尾符
LINES TERMINATED BY '\n' #换行
(address,col_02);
参考:
load data infile "address_200w.csv" into table ethereum_addrs
FIELDS TERMINATED BY ',' #分隔符
ENCLOSED BY '"' #结尾符
LINES TERMINATED BY '\n' #换行
(address,col_02);
参考:
本文标题:csv文件导入mysql数据库
本文链接:https://www.haomeiwen.com/subject/thegkftx.html
网友评论