加载数据文件到MySQL的命令

MySQL命令语句:

LOAD DATA INFILE "{文件}" INTO TABLE dim_iparea FIELDS TERMINATED BY "{分隔符}" LINES TERMINATED BY "{换行符}";

一条SQL语句就搞定~!

Previous Post Next Post

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注