python2连接MySQL并查询

需要使用库pymysql。

示例代码如下，

import pymysql 
conn = pymysql.Connect(
    host='xx.xx.xxx.xx', #ip
    port=xxxx, #端口
    user='xxx', #用户名
    passwd='xxx', #密码
    db='xxx', #数据库名
    charset='utf8'
)
cursor = conn.cursor()
sqlstr = "insert into result_record (run_id, plan_id, mesh_id, input_route_url, memo, citycode) values (%s, %s, %s, %s, %s, %s);"
cursor.executemany(sqlstr, insert_data)
cursor.close()
conn.commit()
conn.close()