python将数据保存到mysql的示例代码：
import MySQLdb# connect MySQL
conn = MySQLdb.connect(
host= ,
user= ,
passwd= ,
db= ,
port= ,
charset='utf8')
cursor = conn.cursor()
filter_merge_len = len(filter_merge_data)
for x in range(filter_merge_len):
try:
cursor.execute(
"insert into database_name.table_name(date,monitor_item, host_ip, cluster\
, software, alarm_hit) values('%s','%s','%s','%s','%s','%d')" %
(yest_date, filter_merge_data.iloc[:, 0][x],
filter_merge_data.iloc[:, 1][x],
filter_merge_data.iloc[:, 2][x],
filter_merge_data.iloc[:, 3][x],
filter_merge_data.iloc[:, 4][x]))
# 提交到数据库执行
conn.commit()
except Exception as e:
print 'Insert Failed'
# close
conn.commit()
cursor.close()
conn.close()
辰迅云「云服务器」，即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘，价格低至29元/月。点击查看>>
推荐阅读： python删除某个字符的方法是什么
云服务器
物理服务器
虚拟主机
跨境电商服务器