sulindong0 2020-04-30
使用的是PyMySql组件
pip3 install PyMySQL
代码
#!/usr/bin/python3 import pymysql # 打开数据库连接 conn = pymysql.connect ( host=‘127.0.0.1‘, port=3306, user=‘root‘, password=‘12345‘, database=‘mysql‘, charset=‘utf8‘ ) cursor = conn.cursor(cursor=pymysql.cursors.DictCursor) # 返回字典数据类型 # 定义将要执行的sql语句 # sql = ‘select user from user;‘ sql = "SELECT user FROM user" # 拼接并执行sql语句 cursor.execute(sql) try: cursor.execute(sql) # 获取所有记录列表 results = cursor.fetchall() for x in results: print(x) except: print ("Error: unable to fetch data") cursor.close() conn.close()