##example

#coding=UTF-8import sysimport MySQLdbimport timereload(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)