MySQL命令语句:
LOAD DATA INFILE "{文件}" INTO TABLE dim_iparea FIELDS TERMINATED BY "{分隔符}" LINES TERMINATED BY "{换行符}";
一条SQL语句就搞定~!
MySQL命令语句:
LOAD DATA INFILE "{文件}" INTO TABLE dim_iparea FIELDS TERMINATED BY "{分隔符}" LINES TERMINATED BY "{换行符}";
一条SQL语句就搞定~!