python mysql connection close,Python数据库连接关闭

数据库连接关闭"/>

python mysql connection close,Python数据库连接关闭

Using the code below leaves me with an open connection, how do I close?

import pyodbc

conn = pyodbc.connect('DRIVER=MySQL ODBC 5.1 driver;SERVER=localhost;DATABASE=spt;UID=who;PWD=testest')

csr = conn.cursor()

csr.close()

del csr

解决方案

Connections have a close method as specified in PEP-249 (Python Database API Specification v2.0):

import pyodbc

conn = pyodbc.connect('DRIVER=MySQL ODBC 5.1 driver;SERVER=localhost;DATABASE=spt;UID=who;PWD=testest')

csr = conn.cursor()

csr.close()

conn.close() #

Since the pyodbc connection and cursor are both context managers, nowadays it would be more convenient (and preferable) to write this as:

import pyodbc

conn = pyodbc.connect('DRIVER=MySQL ODBC 5.1 drive