python连接mysql

example

#coding=UTF-8

import sys
import MySQLdb
import time

reload(sys)
sys.setdefaultencoding(\'utf-8\')

def connectDemo():
    return MySQLdb.Connection(\"127.0.0.1\",\"root\",\"root\",\"demo\",3306,charset=\"utf8\")


if __name__ == \'__main__\':
    begin=time.time()

    conn=connectDemo()
    cursor = conn.cursor()
    sql=\"\"\"
        show tables
        \"\"\"
    count = cursor.execute(sql)
    rows = cursor.fetchall()
    cursor.close()
    conn.close()
    print \"========demo库共:%s 张表============\" % (count)

    print \'耗时:%s 秒\' % (time.time()-begin)