Python MySQL

1.下载并安装MySQLdb模块

2.实例代码：

#-*- coding: utf-8 -*-
import sys, MySQLdb

conn=MySQLdb.connect(host="127.0.0.1", user="root", passwd="password", db="test", charset="utf8")
cursor=conn.cursor()
a = "张三"

sql="insert into users (userno,username) values (%s,%s)"
param=('100000', a)
n = cursor.execute(sql, param)
print n
conn.commit()

n = cursor.execute("select * from users")
for row in cursor.fetchall():
    print row[0]+ ',' + row[1]
cursor.close()
conn.close()

注：表sql:

create table users(
    userno varchar(6),
    username varchar(32)
)