[Python] MySQL 연동하여 DB추가 (mysql-connector-python)

1. MySQL connector 설치
- 아래 사이트 접속하여 설치하거나,
  (https://dev.mysql.com/downloads/connector/python/)

MySQL :: Download Connector/Python

  pip command로 설치 

#cmd
python pip install mysql-connector-python

2, 코드 적용 (ex. table_1.db 에 data1,data2 삽입)

import mysql.connector
Conn = mysql.connector.connect(user='root', password='****',
                               host='127.0.0.1',
                               database='db')
cursor = Conn.cursor()
sql = "INSERT INTO table_1(col1, col2) VALUES (%s, %s)"

cursor.execute(sql, ("data1","data2") )
Conn.commit()
Conn.close()