使用Python操作MySQL

1.下载windows下的MySQLdb

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

下载成功之后，双击它，自动安装到了D:\program files\Python27\Lib\site-packages。

2.用网上的代码

# server_version.py - retrieve and display database server version

   import MySQLdb

   conn = MySQLdb.connect (host = "localhost",
                           user = "testuser",
                           passwd = "testpass",
                           db = "test")
   cursor = conn.cursor ()
   cursor.execute ("SELECT VERSION()")
   row = cursor.fetchone ()
   print "server version:", row[0]
   cursor.close ()
   conn.close ()

在conn = MySQLdb.connect()这句这里报错：

Traceback (most recent call last):
  File "<pyshell#12>", line 1, in <module>
    import MySQLdb
  File "E:/Github/python/20140331\MySQLdb.py", line 7, in <module>
    conn = MySQLdb.connect(host="localhost", user="root", passwd="", db="test",charset="utf8")
AttributeError: 'module' object has no attribute 'connect'

相关资料：

http://stackoverflow.com/questions/372885/how-do-i-connect-to-a-mysql-database-in-python

http://www.kitebird.com/articles/pydbapi.html

http://www.mikusa.com/python-mysql-docs/index.html

https://wiki.python.org/moin/DatabaseProgramming