当前位置:Gxlcms > 数据库问题 > python mysql Connect Pool mysql连接池 (201

python mysql Connect Pool mysql连接池 (201

时间:2021-07-01 10:21:17 帮助过:3人阅读

 easy_install mysql-connector-python

>>>import mysql.connector as conner >>> conn = conner.connect(user="root", passwd="kaimen", db="zentao", port=3306, pool_name = "mypool", pool_size = 3,) >>> cursor = conn.cursor() >>> cursor.execute("show tables"); >>> cursor.fetchall() [(u‘task‘,)]   >>> cursor = conn.cursor(cursor_class=conner.cursor.MySQLCursorDict) >>> cursor.execute("show tables"); >>> cursor.fetchall() [{u‘Tables_in_zentao‘: u‘task‘}]   >>> cursor = conn.cursor(dictionary=True) >>> cursor.execute("show tables"); >>> cursor.fetchall() [{u‘Tables_in_zentao‘: u‘task‘}]

python mysql Connect Pool mysql连接池 (201

标签:

人气教程排行