mysql中导入csv文件

小白刚学mysql，用MySQL将csv文件导入自己建的数据库中，记下些东西：

load data file 用法参考http://blog.csdn.net/pkueecser/article/details/9566377

mysql导入表格先需创建相应表头：

create table ncr(INDEXS  int(4),TRDMN text,SEC_NAME char(20),TRADE_CODE smallint,
                FLOAT_A_SHARES bigint,SHARE_TOTALA bigint,SHARE_NONTRADABLE bigint,
                CLOSENCR float,SUSP_DAYS SMALLINT,
   PE_LYR float,PB_LF float,DIVIDENDYIELD float,TOT_ASSETS bigint default NULL,
                TOT_EQUITY bigint default NULL,OPPROFIT bigint default NULL,TOT_PROFIT bigint default NULL,NET_PROFIT_IS bigint default NULL);

LOAD  DATA  LOCAL INFILE 'C:\\stock data\\asset pricing ncr\\300369.csv' into table ncr   #如果不加local则要导入的csv文件必须在服务器上
character set gbk
fields terminated by ','
enclosed by '"'
lines terminated by '\r\n' 
ignore 1 lines ;  #---忽略原表头