Web/MySQL
import csv
cha-n
2021. 5. 24. 09:16
Import CSV File Into MySQL Table
This tutorial shows you how to use LOAD DATA INFILE statement to import CSV file into MySQL table.
www.mysqltutorial.org
1. table만들고
2.
LOAD DATA INFILE
'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/CSV파일.csv'
INTO TABLE 테이블
FIELDS TERMINATED BY ','
IGNORE 1 ROWS;