sql_insert_1 = "INSERT INTO traffic_hourly_devices(date, time, mobile_traffic, desktop_traffic) VALUES(%s,%s,%s,%s)"
cursor.execute(sql_insert_1, (devices_data.loc[0, 'date'],
devices_data.loc[0, 'time'],
devices_data.loc[0,'mobile_traffic'],
devices_data.loc[0, 'desktop_traffic']))
一开始使用时间格式化,%Y-%m之类的,数字使用%d, 后来发现都是放屁。统统%s才是王道。
https://stackoverflow.com/questions/5785154/python-mysqldb-issues-typeerror-d-format-a-number-is-required-not-str