Python使用数据库

http://www.cnblogs.com/fnng/p/3565912.html
安装MySQL-python

要想使python可以操作mysql 就需要MySQL-python驱动，它是python 操作mysql必不可少的模块。

下载地址：https://pypi.python.org/pypi/MySQL-python/

下载MySQL-python-1.2.5.zip 文件之后直接解压。进入MySQL-python-1.2.5目录:

python setup.py install

import MySQLdbconn=MySQLdb.connect(    host='localhost',    port=3306,    user='root',    passwd='123456',    db='sys',    )cur=conn.cursor()sqli="insert into zdz values(%s,%s)"cur.executemany(sqli,(    ('Jerry','1243'),    ('Jack','2342'),    ('Dsa','4634'),    ))aa=cur.execute("select * from zdz")print aainfo=cur.fetchmany(aa)for li in info:    print licur.close()conn.commit()conn.close()