mysql load data

mysql load data 指定编码

LOAD DATA INFILE 'E://temp//data.txt' IGNORE

INTO TABLE cell_definition_test

CHARACTER SET gbk

FIELDS TERMINATED BY ','

LINES TERMINATED BY '\n' (cgi,msc_id,title,shape_type,lon,lat,radius,angle)

原文地址：http://www.cnblogs.com/alex-blog/articles/2194519.html