[pymysql] pandas 없이 csv라이브러리로 csv파일을 DB에 insert하기

import pymysql
import csv

conn = pymysql.connect(host='localhost', port=3306, user='root', password='비밀번호', db ='DB명', charset='utf8')
cursor = conn.cursor()
conn.commit()

f = open('C:/project/emp_20221115.txt','r')
csvReader = csv.reader(f)
for row in csvReader:
    name = (row[0])
    email = (row[1])
    dept = (row[2])
    salary = (row[3])

    print(name)
    print(email)
    print(dept)
    print(salary)


    sql = """INSERT INTO employee (Name, Email, Department, Salary) VALUES (%s, %s, %s, %s)"""
    cursor.execute(sql, row)

conn.commit()
conn.close()

 

 

 

참고 : https://do-hansung.tistory.com/6

[python] csv의 데이터를 DB insert