Python的MySQLdb模块应该使用SQL语句字符串中的格式说明符实现占位符。我正在遵循MYSQL食谱中的一个示例

import sys
import MySQLdb
import Cookbook

try:
    conn = Cookbook.connect ()
    print("Connected")
except MySQLdb.Error as e:
    print("Cannot connect to server")
    print("Error code:", e.args[0])
    print("Error message:", e.args[1])
    sys.exit (1)

cursor = conn.cursor ()
cursor.execute ("""
                INSERT INTO profile (name,birth,color,foods,cats)
                VALUES(%s,%s,%s,%s,%s)
                """,("Josef", "1971-01-01", None, "eggroll", 4))

但当我从外壳上检查时
mysql> SELECT * FROM profile WHERE name LIKE  'J%';
+----+--------+------------+-------+----------------+------+
| id | name   | birth      | color | foods          | cats |
+----+--------+------------+-------+----------------+------+
|  7 | Joanna | 1952-08-20 | green | lutefisk,fadge |    0 |
+----+--------+------------+-------+----------------+------+

很明显没有插入任何内容。为什么?
如果我按照建议添加cursor.commit
    cursor.commit()
AttributeError: 'Cursor' object has no attribute 'commit'

最佳答案

您没有提交交易。
执行查询后在末尾添加conn.commit()

cursor = conn.cursor()
cursor.execute ("""
            INSERT INTO profile (name,birth,color,foods,cats)
            VALUES(%s,%s,%s,%s,%s)
            """,("Josef", "1971-01-01", None, "eggroll", 4))
conn.commit()

关于python - MySQLdb占位符实现不起作用,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/45348080/

10-11 04:46