python 26 连接 mysql 实例

首先是安装连接mysql的必须的module：MySQL python-1.2.2.win32-py2.6.rar 。具体的下载地址：

http://www.codegood.com/download/2/

测试用代码如下：

#-*- coding: utf-8 -*- import sys, MySQLdb conn=MySQLdb.connect(host="localhost", user="root", passwd="root", db="mytest") cursor=conn.cursor() n = cursor.execute("select * from stu") for row in cursor.fetchall(): print row[0],'-->',row[1] cursor.close() conn.close()