python 操作mysql

1. 

注意：一定要  db.commit() ，不然命令无法生效

import pymysql
import requests
import json

db = pymysql.connect("rdsbjagatetest.mysql.rds.aliyuncs.com", "infosec_user", "NWd0RKVK","infosec_rule_engine")
cursor = db.cursor()
 sql = "insert into infosec_rule_engine.cmdb_ip set id={0}, innerip='{1}', env='{2}', p_dev='{3}',p_ops='{4}', dept='{5}';".format(tmp_dict['id'],tmp_dict['innerip'], tmp_dict['env'], tmp_dict['p_dev'],
                                                                     tmp_dict['p_ops'], tmp_dict['dept'])

cursor.execute(sql)
db.commit()
db.close()

执行 select 操作返回的是 tuple