- # coding=utf-8
- #引入mysql python客户端模块
- import MySQLdb
- import 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
来源: http://www.phpxs.com/code/1004817/