代码如下:
import pymysql
# 端口默认3306
conn=pymysql.connect(host='xxx.xxx.xx.xxx',user='xxx',passwd='xxx',db='xxx')
cur=conn.cursor(pymysql.cursors.DictCursor)
cur.execute('select * from tabdata');
import pymysql
# 端口默认3306
conn=pymysql.connect(host='xxx.xxx.xx.xxx',user='xxx',passwd='xxx',db='xxx')
cur=conn.cursor(pymysql.cursors.DictCursor)
cur.execute('select * from tabdata');