鍍金池/ 問答/Python  數(shù)據(jù)庫/ python 插入mysql 報錯

python 插入mysql 報錯

{"downNum": 8, "exposeNum": 4296, "ctr": 0.19, "price": 6.6, "cost": 52.8, "ecpm": 12.29, "dt": 20180221}
Traceback (most recent call last):
  File "/home/stephen/loading/Oppo/oppo.py", line 700, in <module>
    oppo.login_in()
  File "/home/stephen/loading/Oppo/oppo.py", line 55, in login_in
    self.Promotion_manage(manage_page_response.encode("utf-8"),login_token_headers)
  File "/home/stephen/loading/Oppo/oppo.py", line 305, in Promotion_manage
    self.report_list(manage_page_data[i], manage_page_data[i - 10 + 2 - 1],login_token_headers)
  File "/home/stephen/loading/Oppo/oppo.py", line 673, in report_list
    id3="select id from oppo_feeds_stat_total_report where account_id =%d and report_date='%s';"%((int)(account_id),report_date)
    
   
ValueError: invalid literal for int() with base 10: 'select id from oppo_feeds_stat_ad_img_report where account_id =1000016702 and ad_id=256245;'

id = "select id from oppo_feeds_stat_ad_img_report where account_id =%d and ad_id=%d;"%((int)(account_id),(int)(ad_id[k]))

回答
編輯回答
款爺

字面意義非常明確,無法轉(zhuǎn)換為 int 類型。
如果傳入的字符串為‘’,將會報錯。

2017年4月23日 00:37