通过Python3.6 连接mysql数据库 导入mysqldb报错 #!/usr/bin/python # -*- coding: UTF-8 -*- import pymysql # 打开数据库连接 db = pymysql.connect("localhost", "用户名", "密码", "数据库名", charset='utf8' ) # 使用cursor()方法获取操作游标 cursor = db.cursor() # 创建数据表SQL语句 sql = """select * from gang""" cursor.execute(sql) try: # 执行SQL语句 cursor.execute(sql) # 获取所有记录列表 results = cursor.fetchall() for row in results: name = row[0] age = row[1] # 打印结果 print ("name=%s,age=%s" % \ (name, age ) ) except: print ("Error: unable to fecth data") # 关闭数据库连接 db.close()
执行成功: