csv表中含有中文字符,具體實現代碼示例:
load data infile ‘C:UsersAdministratorDesktopimportCELLutf.csv’ into table cell character set gbk(設置gbk字符編碼,防止出現中文亂碼)
fields terminated by ‘,’
enclosed by ‘”‘
lines terminated by ‘ ‘
IGNORE 1 LINES;
代碼解釋:
fields terminated by ‘,’:csv文件中數據之間的分隔符,csv文件默認以逗號分隔;
enclosed by ”:指出封套符;
lines terminated by ”:指行終止符;
IGNORE 1 LINES:忽略csv表頭。
? 版權聲明
文章版權歸作者所有,未經允許請勿轉載。
THE END