python---连接MySQL第四页
标签：
python---连接MySQL第四页
!conding:utf-8
from mysql.connector import errorcode
import mysql.connector
cnx=None
cursor=None
try:
cnx = mysql.connector.connect(host=‘192.168.1.201‘,port=3306,user=‘admin‘,password=‘131417‘)
cursor=cnx.cursor(buffered=True)#buffered=True会把结果集保存到本地，这样可以提高性能
cursor.execute(‘select * from studio.t where id=7‘)
for x in cursor:
print x
except mysql.connector.Error,err:
print err
finally:
if cursor is not None:
cursor.close()
cnx.close()