因為Windows Azure註冊出了問題，目前我還沒測試。
網路上查到的
Windows Azure的mysql連結參數：
db = MySQLdb.connect(host= "windows azure url goes here",user="uname",passwd="pwd",db="dbname")
不過 Pythone所提供的mysql連結參數：
db = MySQLdb.connect(host= "host","uname","pwd","dbname")
這語法得再查證，不過除了連結資料庫不同外，Windows Azure的mysql還得做以下兩件事情
1.防火牆上開啟3306
2.針對你的資料庫設定一個連線帳號，例如
GRANT ALL ON SOMEDATABASE.* TO USERNAME@% IDENTIFIED BY 'SOMEPASSWORD'
python新增與查詢的參考語法
import MySQLdb
# Open database connection
db = MySQLdb.connect("localhost","testuser","test123","TESTDB" )
# prepare a cursor object using cursor() method
cursor = db.cursor()
# Select qSQL with id=4.
cursor.execute("SELECT qSQL FROM TBLTEST WHERE id = 4")
# Fetch a single row using fetchone() method.
results = cursor.fetchone()
qSQL = results[0]
cursor.execute(qSQL)
# Fetch all the rows in a list of lists.
qSQLresults = cursor.fetchall()
for row in qSQLresults:
id = row[0]
city = row[1]
#SQL query to INSERT a record into the table FACTRESTTBL.
cursor.execute('''INSERT into FACTRESTTBL (id, city)
values (%s, %s)''',
(id, city))
# Commit your changes in the database
db.commit()
# disconnect from server
db.close()
MySQL與python可參考：
http://www.tutorialspoint.com/python/python_database_access.htm
