python - 为什么我不能在 MYSQL 中执行此 INSERT？ ( python MySQLdb)

Question

这是我之前提出的这个问题的后续: Why can't I insert into MySQL?

这个问题部分解决了它。现在我正在用 Python 做它，但它不起作用 :(

cursor.execute("INSERT INTO life(user_id, utm)  values(%s,PointFromWKB(point(%s,%s)))",the_user_id, utm_easting, utm_northing)

我什至做了 float(utm_easting) 和 float(utm_northing)

编辑:这是错误:

execute() 最多接受 3 个参数(给定 5 个)

Answer 1

来自 here (pdf) :

Following the statement string argument to execute(), provide a tuple containing the values to be bound to the placeholders, in the order they should appear within the string. If you have only a single value x, specify it as (x,) to indicate a single-element tuple.

tl;博士:

cursor.execute("""INSERT INTO life(user_id, utm) 
    values(%s,PointFromWKB(point(%s,%s)))""", 
    (the_user_id, utm_easting, utm_northing))

编辑:您也可以将列表作为 execute() 的第二个参数传递。

cursor.execute("""INSERT INTO life(user_id, utm) 
    values(%s,PointFromWKB(point(%s,%s)))""", 
    [the_user_id, utm_easting, utm_northing])