L의 공간/Python
2022. 2. 1.
[Python] Python-MySql 연동하기 with PyMySql
PyMySql DB 연결 import pymysql conn = pymysql.connect(user='유저명', passwd='패스워드', host='IP', db='데이터베이스명', charset='utf8') cursor = conn.cursor() PyMySql 쿼리 실행 (단일행 삽입) query = "INSERT INTO post (id, name, title, link, published, topic, platform) VALUE (0, %s, %s, %s, %s, %s, %s)" data = (name, title, link, published, topic, platform) cursor.execute(query, data) conn.commit() PyMySql 쿼리 실행 (다중행 삽입)..