python3 链接mysql 需要自己搞定pymysql模块

importpymysql
importhashlib,urllib
n ='123456'.encode()
m =hashlib.md5(n).hexdigest()

#创建链接对象
conn = pymysql.connect(host='127.0.0.1',port=3306,user='root',passwd='',db='python')
#创建游标
cursor = conn.cursor()
#执行sql，更新单条数据，并返回受影响行数
effect_row = cursor.execute("update pymysql set name = 'aaa'WHERE id in(1,2,3)")
print(effect_row)
#插入多条，并返回受影响的函数
effect_row = cursor.executemany("insert into pymysql(name,pwd)values(%s,%s)",[("jason",m),("jason",m),("jason",m)])
print(effect_row)
#获取最新自增ID
new_id = cursor.lastrowid
#查询数据
cursor.execute("select*from pymysql")
#获取一行
# row_1 = cursor.fetchone()
#获取多(3)行
row_2 = cursor.fetchmany(3)
print(row_2)
#获取所有
row_3 = cursor.fetchall()
print(row_3)
#重设游标类型为字典类型
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
#提交，保存新建或修改的数据
conn.commit()
#关闭游标
cursor.close()
#关闭连接
conn.close()