Windows下安装MySQL-python
下载地址:https://pypi.python.org/pypi/MySQL-python/1.2.5 安装到系统即可。...linux下安装MySQL-python以连接MySQL:
下载地址:https://pypi.python.org/pypi/MySQL-python/
解压后,进入目录下,执行python setup.py...然后执行 /etc/init.d/mysql restart重启mysqlserver服务即可
# 下面是一个Python操作数据库的例子:
#!...sqli="insert into teacher values(%s,%s,%s,%s)"
cur.execute(sqli, (23,'zhangsan','science',15))
# 使用executemany...sqli="insert into teacher values(%s,%s,%s,%s)"
cur.executemany(sqli,[
(11,'wangwu','art',23),
(8,'john