python3.3链接mysql5.1

1.连接mysql组件

   以前第三方提供的最高支持python2.7的数据连接,python3.3无法使用.

2.使用mysql官方提供的api支持python3.3

  下载地址:http://dev.mysql.com/downloads/connector/python/1.0.html mysql-connector-python-1.0.12-py3.3.msi

3.安装上述下载的组件.可以开始使用python3.3操作mysql数据库

4.创建数据库mydata,使用Navicat快速创建.

             

5.使用python3.3操作

#-------------------------------------------------------------------------------
# Name:        daatbase.py
# Purpose:
#
# Author:      Administrator
#
# Created:     22/10/2013
# Copyright:   (c) Administrator 2013
# Licence:     <your licence>
#-------------------------------------------------------------------------------
import mysql.connector
from mysql.connector import errorcode

#DB的资料换成本机的数据库链接资料
db=mysql.connector.connect(host='localhost',user='user',passwd='pwd',db='db')
cur=db.cursor()
cur.execute('insert into username(username,userpwd,memo) values(\'wucc\',\'wucc\',\'this is wucc\')')
db.commit()
ur.execute('delete from username where id=1')
db.commit()

r=cur.execute('select * from username')
r=cur.fetchall()
print(r)
cur.close()
db.close()