【python】 win10 pyodbc连接mysql

一、环境

windows10

python3.8

mysql 5.0.11

二、安装pyodbc

win键+R > cmd >：

pip install pyodbc

三、ODBC驱动配置

下载驱动链接：https://dev.mysql.com/downloads/connector/odbc/

按正常步骤默认安装，成功后

三、代码

查看可用ODBC驱动

import pyodbc
print(pyodbc.drivers())

运行结果：

DBHelper

#coding:utf-8
import pyodbc
 
class DBHelper(object):
 
    def __init__(self, host, port, database, user, password):
        #conn_info = 'Driver={SQL Server};Database=%s;Server=%s,%s;Uid=%s;Pwd=%s' % (dbName, serverIp, port, uid, pwd)
        conn_info = ('Driver={MySQL ODBC 8.0 Unicode Driver};Server=%s;Port=%s;Database=%s;User=%s; Password=%s;Option=3;'%(host, port, database, user,password))
        self.connection = pyodbc.connect(conn_info, unicode_results=True)
        self.cursor = self.connection.cursor()
 
    def __del__(self):
        if self.cursor:
            self.cursor.close()
            self.cursor = None
        if self.connection:
            self.connection.close()
            self.connection = None
 
    def destroy(self):
        if self.cursor:
            print(self.cursor, 'destroy cursor closed')
            self.cursor.close()
            self.cursor = None
        if self.connection:
            self.connection.close()
            self.connection = None
 
    # 获取全部查询结果
    def query(self, sql):
        self.cursor.execute(sql)
        return self.cursor.fetchall()
  
    #获取查询条数
    def count(self, sql):
        self.cursor.execute(sql)
        return self.cursor.fetchone()[0]
 
    #执行语句，包括增删改，返回变更数据数量
    def execute(self, sql):
        count = self.cursor.execute(sql).rowcount
        self.connection.commit()
        return count

db = DBHelper('localhost',3306,'test','root','root')
list = db.query('select * from users limit 5')
print(list)

输出：

其它帮助链接很详细：

https://blog.csdn.net/weixin_44663675/article/details/93173408

https://blog.csdn.net/buptlihang/article/details/80275641

https://blog.csdn.net/cn130404/article/details/74370377