[python] pymysql

설치

pip install pymysql

 

 

사용

import pymysql

Host = "xxx.xxx.xx.xxx"
User = "userid"
Pass = "userpw"
DdataB = "db_name"

conn = pymysql.connect(
	host=Host,
	user=User,
	password=Pass,
	database=DdataB
)
cur = conn.cursor()

sql = " SELECT * FROM ......... "
cur.execute(sql)

result = cur.fetchone()	# 1개
result = cur.fetchall()	# 여러개



sql_up = " UPDATE ... "
cur.execute(sql_up)
conn.commit()


conn.close()