python mysql insert

樂悠悠

各位大大好～小弟使用python 寫入mysql時一直出現_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''sha1', 'resource', 'response_code', 'scan_date', 'sha256', 'positives', 'total'' at line 1")

原碼如下：
        a = str(json_response.get('sha1'))
        b = str(json_response.get('resource'))
        c = int(json_response.get('response_code'))
        d = str(json_response.get('scan_date'))
        e = str(json_response.get('sha256'))
        f = int(json_response.get('positives'))
        g = int(json_response.get('total'))
        h = str(json_response.get('md5'))
       
        conn = MySQLdb.connect(host, user, passwd, db)
        cur = conn.cursor()
        writelog = ("insert into vt_scan('sha1', 'resource', 'response_code', 'scan_date', 'sha256', 'positives', 'total', 'md5')values ('%s','%s', '%s', '%s', '%s', '%s', '%s', '%s')" % (a, b, c, d, e, f, g, h))
        cur.execute(writelog)
        conn.commit()

到底是錯在哪有哪位大大可以幫解決一下嗎？

玉轩辕

不明白原因，刚进入学习PYTHON 阶段。

爱，不解释

加油

梦里不知身是客

sql语句里面 字段名不用加引号的，

zhijianwomen

sql语句里面 字段名不用加引号的，insert into table_name （column_name1，column_name2，column_name3....）values(....)

fishc1008

sql语句里面 字段名不用加引号的，

fishc1008

好像是这样