python mysql添加参数_Python与mysql查询插入单参数

下面是不工作的代码#!/usr/bin/python

import urllib

import datetime

import mysql.connector

data['price'] = 100

# Write to database

cnx = mysql.connector.connect(user='user', password='pw', database='db')

cursor = cnx.cursor()

query = ("INSERT INTO records(price) VALUES(%s) ")

cursor.execute(query, (data['price']))

cnx.commit()

cursor.close()

cnx.close()

MySQL有相应的表和列。在id(主整数自动增量)

价格(浮动)

没有连接问题。在

它给出了以下错误。有什么想法吗？在Traceback (most recent call last): File "./sys-fetchdata.py", line

22, in

cursor.execute(query, (data['price'])) File "/usr/lib/python2.7/dist-packages/mysql/connector/cursor.py", line

507, in execute

self._handle_result(self._connection.cmd_query(stmt)) File "/usr/lib/python2.7/dist-packages/mysql/connector/connection.py", line

722, in cmd_query

result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File

"/usr/lib/python2.7/dist-packages/mysql/connector/connection.py", line

640, in _handle_result

raise errors.get_exception(packet) mysql.connector.errors.ProgrammingError: 1064 (42000): 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 '%s)' at line 1