python 全局mysql_python如何连接MySQL数据库

#!/usr/bin/env python

# -*-coding:UTF-8-*-#这一句告诉python用UTF-8编码

#=========================================================================

#

# NAME: Python MySQL test

#

# AUTHOR: benyur

# DATE  : 2004-12-28

#

# COMMENT: 这是一个python连接mysql的例子

#

#=========================================================================

"""

***** This is a MySQL test *****

select:

conn=Connection()

conn.select_db('test')

cur=conn.cursor()

cur.execute('select * from user')

cur.scroll(0)

row1=cur.fetchone()

row1[0]

row1[1]

row1[2]

insert:

cur.execute('insert into user (name,passwd) values('benyur','12345')')

cur.insert_id()

update:

cur.execute('update user set passwd='123456' where name='benyur'')

delete:

cur.execute('delete from user where id=2')

**********************************

"""

from MySQLdb import *

def conn():

conn=Connection()

conn.select_db('test')

cur=conn.cursor()

cur.execute('select * from user')

cur.scroll(0)

row1=cur.fetchone()

row1[0]

row1[1]

row1[2]

def usage():

print __doc__

if __name__=='__main__':

usage()

MySQLdb下载地址：http://sourceforge.net/projects/mysql-python/

下载解压缩后放到%Python_HOME%Libsite-packages目录中，python会自动找到此包。

MySQLdb基本上是MySQL C API的Python版，遵循Python Database API Specification v2.0。