python mysql Connect Pool mysql串連池 (201

標籤：

 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