mysql 导入csv 文件

1. 获取 mysql 配置文件路径

?

1	mysqld --verbose --help | grep .cnf

2. mysqld 文件添加配置

?

1 2 3

[mysqld] ... secure-file-priv = ""

 3. 建表

create table t_table ( bank_code text, bank text);

4. 导入csv 文件

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Bank Code,Bank（表头提前移除） ACEH,ACEH AGRONIAGA,Bank Rakyat Indonesia AGRONIAGA ANZ,ANZ ARTHA,ARTHA ARTOS,ARTOS BALI,BALI BANTEN,BANTEN BCA,BCA BCA_SYR,BCA_SYR BNI,BNI BOC,BOC BRI,BRI BSI,BSI BTN,BTN

load data infile '/Users/logs/t.csv'  
into table tmp.t_table
fields terminated by ',' optionally enclosed by '"' escaped by '"' 
lines terminated by '\n';