python中数据库操作

import pymysql
db = pymysql.connect(host='localhost', port='port', user='root', passwd='password', db='testapp', charset='utf8')
cursor = db.cursor()
sql = "SELECT * FROM 表 where id = '13'"
cursor.execute(sql)
data = cursor.fetchone()
db.close()

代码编辑如下