python连接mysql查询数据示例，pythonmysql,使用MySQLdb模块连

使用MySQLdb模块连接MySQL```python

coding=utf-8

引入mysql python客户端模块

import MySQLdbimport sys

进行数据库连接

conn = MySQLdb.connect(host="localhost", user="root", passwd="123456", db="pythontab", charset="utf8")cursor = conn.cursor()

执行sql

cursor.execute("select * from test")

列出数据

records = cursor.fetchall()for row in records: for r in row: print r```