å©ç¨mysqlæ件 pymysqlï¼åinsertè¯å¥ç´æ¥æå
¥å°æ°æ®åº
å®è£
ï¼pip install pymysqlã
代ç ï¼excute_sqlæ¹æ³æ¯æ§è¡æ´æ°ï¼æå
¥æä½ãget_datassetæ¹æ³æ¯æ¥è¯¢ã
# coding: utf-8
import pymysql.cursors
def execute_sql(sql):
conn = pymysql.connect(host='127.0.0.1',port = 3306,user='root',passwd='123456',db ='db',charset="utf8")
try:
with conn.cursor() as cursor:
cursor.execute(sql)
conn.commit()
finally:
conn.close()
def get_dataset(sql):
conn = pymysql.connect(host='127.0.0.1',port = 3306,user='root',passwd='123456',db ='db',charset="utf8")
try:
with conn.cursor() as cursor:
cursor.execute(sql)
return cursor.fetchall()
finally:
conn.close()