python操作mysql数据库的简单范例演示的代码

将做工程过程中经常用到的内容段做个备份，下面内容是关于python操作mysql数据库的简单范例演示的内容，应该能对小伙伴们有用途。

#!/usr/bin/python

import MySQLdb

# Open database connection

db = MySQLdb.connect("localhost","testuser","test123","TESTDB" )

# prepare a cursor object using cursor() method

cursor = db.cursor()

# execute SQL query using execute() method.

cursor.execute("SELECT VERSION()")

# Fetch a single row using fetchone() method.

data = cursor.fetchone()

print "Database version : %s " % data

# disconnect from server

db.close()