python pyodbc mysql,【python】 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)

```

输出：