import csv

 

https://www.mysqltutorial.org/import-csv-file-mysql-table/#:~:text=Importing%20CSV%20file%20using%20MySQL%20Workbench&text=The%20following%20are%20steps%20that,which%20the%20data%20is%20loaded.&text=Review%20the%20data%2C%20click%20Apply,insert%20data%20into%20the%20table.

Import CSV File Into MySQL Table

1. table만들고

2. 

LOAD DATA INFILE  
'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/CSV파일.csv' 
INTO TABLE 테이블 
FIELDS TERMINATED BY ','
IGNORE 1 ROWS;