import pymysql.cursors
conn = pymysql.connect(host='172.18.18.20',
port=3306,
user='root',
password='root',
db='isap',
charset='utf8',
cursorclass=pymysql.cursors.DictCursor)
cursors = conn.cursor()
print(row_all)
conn.commit()
cursors.close()
conn.close()
conn = pymysql.connect(host='172.18.18.20',
port=3306,
user='root',
password='root',
db='isap',
charset='utf8',
cursorclass=pymysql.cursors.DictCursor)
cursors = conn.cursor()
cursors.execute("select * from t_alert")
#获取所有数据
#若想获取第一条数据则,row_1=cursors.fetchone()
row_all = cursors.fetchall()print(row_all)
conn.commit()
cursors.close()
conn.close()