在python 3.2 中連接MYSQL的方式有很多種，例如使用mysqldb,pymysql。本文主要介紹使用Pymysql連接MYSQL的步驟

1        安裝pymysql

·        確保python3.2已經正確安裝

·        從 https://pypi.python.org/pypi/PyMySQL3 下載安裝包

·        解壓到指定的路徑

·        在命令行模式下進入安裝目錄，執行 python setup.py install命令

2        SimpleSample

    ''''' 

    Created onDec 17, 2013 



    @author:aihua.sun 

    '''  

    importpymysql;  



    defaccess_mysql():  

        conn = pymysql.connect(host='localhost', port=3306,user='root',db='test')  

        cur = conn.cursor()  

        cur.execute("SELECT * FROM dictionarylimit 10")  

        for r in cur:  

           print("row_number:"+str(cur.rownumber))  

            print("id:"+str(r[0])+"key:"+str(r[1])+" mean:"+str(r[2]))  

        cur.close()  

        conn.close()  



    if __name__== '__main__':  

        access_mysql();  

3        Referenceresources

http://pymssql.sourceforge.net/ref_pymssql.php