分享csv導入數據到mysql實例

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
喜歡就支持一下吧
點贊6 分享