一、首先需要到官网下载MySQL-python-1.2.3.win-amd64-py2.7.exe,双击安装包就可以自动安装,一直next就好了。
二、新建一个python工程,新建module文件,下面帖代码示例:
示例一:连接数据库
# coding:utf-8
'''
Created on 2016��6��14��
@author: Administrator
'''
import MySQLdb
# conn 数据库连接对象
conn=MySQLdb.Connect(
host='127.0.0.1', #MySql服务器地址
port=3306, # MySql监听端口
user='root', #Mysql用户名
passwd='1234', # Mysql用户密码
db='pythondb',# 数据库名称
charset='utf8' #编码
)
cursor=conn.cursor() # 返回cursor对象
sql="select * from db1"
cursor.execute(sql) #调用cursor的execute()方法来执行sql语句
print cursor.rowcount #操作表的记录行数
rs=cursor.fetchone() #游标移到下一行,取回上一行数据
print rs
rs=cursor.fetchmany(2) #游标下移动两行,取回上两行数据
print rs
rs=cursor.fetchall() #游标移动到底部,取回剩下的数据
print rs
cursor.close() #关闭cursor数流
conn.close() #关闭conn数据流
实例二:对数据库表数据的增删该
# coding:utf-8
'''
Created on 2016��6��14��
@author: Administrator
'''
import MySQLdb
conn = MySQLdb.Connect(
host='127.0.0.1',
port=3306,
user='root',
passwd='1234',
db='pythondb',
charset='utf8'
)
cursor = conn.cursor()
sql_insert = "insert into db1 (userId,name) values(14,\"编程\")"
sql_update = "update db1 set name=\"三国志\" where userId=5"
sql_delete = "delete from db1 where userId<3"
try: #捕获异常
cursor.execute(sql_insert)
print cursor.rowcount
cursor.execute(sql_update)
print cursor.rowcount
cursor.execute(sql_delete)
print cursor.rowcount
conn.commit() #提交事务
except Exception as e:
print e
conn.rollback() #回滚事务
cursor.close()
conn.close()