练习

import pymysql,redis,json
r=redis.Redis(host='118.xx.xx.xxx',password='xxxc&*',db=1)

coon=pymysql.connect(
    host='118.xx.xx.xx',user='xxx',passwd='123456',
    port=3306,db='xxx',charset='utf8'
)


cur=coon.cursor(cursor=pymysql.cursors.DictCursor)
cur.execute('select * from my_user; ')

all_data=cur.fetchall()

for  data  in all_data:
    k=data.get('username')
    r.hset('stu_info_jd',k,json.dumps(data))
cur.close()
coon.close()