当前位置:Gxlcms > 数据库问题 > 连接mysql

连接mysql

时间:2021-07-01 10:21:17 帮助过:20人阅读


user=‘jxz‘,passwd=‘123456‘,
port=3306,db=‘jxz‘,charset=‘utf8‘)#必须写utf8
cur = conn.cursor(cursor=pymysql.cursors.DictCursor) 将元组转换成字典或者list(根据fetchOne 或者fetchall 决定)
sql=‘select * from bt_stu limit 5‘
cur.execute(sql)
print(cur.fetchone())
print(cur.fetchall())
运行结果:

字典:

{‘sex‘: 1, ‘class‘: ‘靠山屯‘, ‘type‘: 1, ‘id‘: 502, ‘real_name‘: ‘秋香‘, ‘phone‘: ‘18612341231‘}  
list:

[{‘sex‘: 1, ‘class‘: ‘天蝎座3‘, ‘type‘: 1, ‘id‘: 503, ‘real_name‘: ‘王兰‘, ‘phone‘: ‘18723561789‘}, {‘sex‘: 1, ‘class‘: ‘截路财‘, ‘type‘: 1, ‘id‘: 506, ‘real_name‘: ‘修仙‘, ‘phone‘: ‘18688866686‘}, {‘sex‘: 1, ‘class‘: ‘靠山屯‘, ‘type‘: 1, ‘id‘: 508, ‘real_name‘: ‘贾梦缘‘, ‘phone‘: ‘18612333231‘}, {‘sex‘: 1, ‘class‘: ‘靠山屯‘, ‘type‘: 1, ‘id‘: 511, ‘real_name‘: ‘爱仕达‘, ‘phone‘: ‘18332341231‘}]

 

 

连接mysql

标签:passwd   数据库   char   语句   .com   none   根据   数据   print   

人气教程排行