从csv文件中导入数据到MySQL数据库

一、Workbench客户端导入（8.0.11基本导不全且速度奇慢）

1.点击如下图标创建数据库（非必要）

 

2.在表类上右键导入

 

二、SQL语句导入（可先用上步导入，再清除数据，这样可免去设置格式等问题）

基本语法：

 

load data [low_priority | concurrent]  [local]  infile  'file_name'

[replace | ignore]

INTO TABLE tbl_name

[partition (partition_name [, partition_name] ...)] [character set charset_name]

[ { fielsd | columns }

[terminated by 'string']

[[optionally]  enclosed by 'char']

[escaped by 'char'] ]

[LINES

[STARTING BY 'string']

[TERMINATED BY 'string']

]

[ignore number  { LINES |