Python连接mysql

工具选择 

mysql-5.5.20-win32.msi       Python2.7.3         MySQL-python-1.2.3.win32-py2.7

首先确保你已安装了mysql数据库。

Python2.7.3 和MySQL-python-1.2.3.win32-py2.7可以去官网下载，也可以从下面下载（这是我上传到网盘的）

http://download.csdn.net/detail/spring292713/4551979

安装步骤（Windows7， 32位）

1、Python2.7.3 的安装可参考我的博文  http://blog.csdn.net/spring292713/article/details/7949962

2、下载好 MySQL-python-1.2.3.win32-py2.7 ，双击即可安装

测试代码：

创建数据库 Python   (注意将数据库的用户名、密码、端口号改成你自己的)

# -*- encoding: utf-8-*- 
import MySQLdb
conn = MySQLdb.connect(host="localhost", user="root", passwd="123456",charset='utf8',port=3308)
cur = conn.cursor()
sql = 'create database Python'
cur.execute(sql)
conn.commit()
cur.close()
conn.close()

创建数据库表user

import MySQLdb
conn = MySQLdb.connect(host="localhost", user="root", passwd="123456", db="Python", port=3308)
cur = conn.cursor()
sql = "create Table user(id int(10) primary key,name char(30) unique,password char(30))"
cur.execute(sql)
conn.commit()
cur.close()
conn.close()

向user表中插入数据

<span style="font-size:14px;">import MySQLdb
conn = MySQLdb.connect(host="localhost", user="root", passwd="123456", db="Python", port=3308)
cur = conn.cursor()
for i in range(1, 20):
    id = i
    name = 'user_' + str(i)
    pwd = 'passwd_' + str(i)
    sql = "insert into user(id,name,password) values('" + id + ','+ name + "','" + pwd + "')"
    cur.execute(sql)
conn.commit()
cur.close()
conn.close()</span>

查询

import MySQLdb
conn = MySQLdb.connect(host="localhost", user="root", passwd="123456",db="Python",port=3308)
cur = conn.cursor()
sql = "select * from user" 
#sql = "select * from _user where id=2" 
#sql = "select name,password from _user where id<12 and id>5"
#sql = "select name,password from _user where id in (3,5,7)"
cur.execute(sql)
rows = cur.fetchall()
for i in rows :
    print i
conn.commit()
cur.close()
conn.close()