Python operation MySQL Database

1.connect

def conn(ip,user,password,database):    con = mdb.connect(ip,user,password,database)    cur = con.cursor()    return cur

2.select
SELECT ip,env from the hosts ORDER by 1, 2
For row in Cur.fetchall ():
Print row
(' 172.x.x.x ', ' prod ')

(' problem:172.x.x.x Table open cache too small\r\nservice_name:table open cache too small\r\nservice_status:problem\r\n Service_severity:information\r\nitem values:\r\ncheck_service_ip:172.x.x.x\r\ncheck_service_name:mysql.status[ open_tables]\r\ncheck_service_vlaue:4059\r\ncheck_service_time:2018.03.01 09:54:43 ',)

3.update

Python operation MySQL Database