python操作mysql
http://stackoverflow.com/questions/372885/how-do-i-connect-to-a-mysql-database-in-python
1, 下载MySQLdb: http://sourceforge.net/projects/mysql-python/files/
2, 如下python代码
#!/usr/bin/python import MySQLdb db = MySQLdb.connect(host="localhost", # your host, usually localhost user="john", # your username passwd="megajonhy", # your password db="jonhydb") # name of the data base # you must create a Cursor object. It will let # you execute all the query you need cur = db.cursor() # Use all the SQL you like cur.execute("SELECT * FROM YOUR_TABLE_NAME") # print all the first cell of all the rows for row in cur.fetchall() : print row[0]