将csv导入mysql（代码列表）

Question

So I have a list of codes (100,000) to be exact and I got them delivered in a csv file.

I want to put theses codes in a database so I can later get them using my php script. However my question is how do I get my codes from the file in the right table?

This is what my database looks like at the moment.

The codes from the file need to be inserted in table code. Hope someone can help me out with this one.

Answer 1

You probably will find this helpful (pls adjust the table and others names):

LOAD DATA INFILE 'codes.csv'
INTO TABLE codes
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '
'
IGNORE 1 ROWS; 
(@id,code,@active)
SET id = null;
SET active = '1'

More details: http://www.mysqltutorial.org/import-csv-file-mysql-table/