python - 數據無法插入到mysql表里
問題描述
# -*- conding:utf8 -*-import tushare as tsimport pymysqltoday_data = ts.get_today_all()conn = pymysql.connect(host=’127.0.0.1’, port=3306, user=’root’, passwd=’root’, db=’test’)cursor = conn.cursor() #創建游標cursor.execute('INSERT INTO today_data(code_code,name_name,changepercent,trade,open_open,high_high,low_low,settlement,volume,turnoverratio,amount,per,pb_pb,mktcap,nmc) VALUES (’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’)',format(code_code,name_name,changepercent,trade,open_open,high_high,low_low,settlement,volume,turnoverratio,amount,per,pb_pb,mktcap,nmc))cursor.close()
上面是代碼,下面是報錯信息
[Getting data:]#######################################Traceback (most recent call last): File 'C:/Users/Administrator/PycharmProjects/untitled/test.py', line 7, in <module> cursor.execute('INSERT INTO today_data(code_code,name_name,changepercent,trade,open_open,high_high,low_low,settlement,volume,turnoverratio,amount,per,pb_pb,mktcap,nmc) VALUES (’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’,’{}’)',format(code_code,name_name,changepercent,trade,open_open,high_high,low_low,settlement,volume,turnoverratio,amount,per,pb_pb,mktcap,nmc))NameError: name ’code_code’ is not defined
test中是有today_data表的,表里也有這些字段,變量today_data獲取到的數據也有這些字段,求指導
問題解答
回答1:異常不是提示你了么?code_code 變量沒有定義
相關文章:
1. docker-compose中volumes的問題2. golang - 用IDE看docker源碼時的小問題3. dockerfile - [docker build image失敗- npm install]4. angular.js - angular內容過長展開收起效果5. mysql - 記錄開始時間和結束時間,表字段類型用timestamp還是datetime?6. 表單提交驗證,沒反應,求老師指點7. node.js - 微信的自動回復問題8. 用Python調用api之后,沒有輸出該如何解決?9. 老師,樣式沒有變呀?10. mysql函數unix_timestamp如何處理1970.1.1以前的數據?

網公網安備