csv文件及百万数据导入操作

一：csv文件是标准的导入导出文件格式，实际上是一个txt文件，文件的第一行是字段标题，字段用逗号隔开。

id,breast,adipocytes,Negative,Staining,Supportive
ENSG00000000003,soft tissue 1,adipocytes,Negative,Staining,Supportive
ENSG00000000003,soft tissue 2,adipocytes,Negative,Staining,Supportive
ENSG00000000005,breast,adipocytes,None,APE,Very low
ENSG00000000005,soft tissue 1,adipocytes,None,APE,Very low
ENSG00000000005,soft tissue 2,adipocytes,None,APE,Very low
ENSG00000000419,breast,adipocytes,Moderate,Staining,Uncertain
ENSG00000000419,soft tissue 2,adipocytes,Moderate,Staining,Uncertain
ENSG00000000457,breast,adipocytes,Weak,Staining,Uncertain
ENSG00000000457,soft tissue 1,adipocytes,Weak,Staining,Uncertain
ENSG00000000457,soft tissue 2,adipocytes,Weak,Staining,Uncertain
ENSG00000000460,breast,adipocytes,Low,APE,Very low
ENSG00000000460,soft tissue 1,adipocytes,Low,APE,Very low
ENSG00000000460,soft tissue 2,adipocytes,Low,APE,Very low

二：采用SQLyong Ultimate导入百万数据。

1.新建数据库testBigDate

右键选中import------>import External Data... 如图所示

2.下一步到如图所示 选中csv

3.依次继续下一步

4.开始运行

5.导入完成，数据库表名默认为文件名！！！