Python 无法向 MySQL 插入行

Question

我正在尝试完成以下查询:

sql = "INSERT INTO adr_citydistricts (CityDistrict, CityDistrictRU) VALUES (% (ua) s,% (ru) s);"
data = {'ua': 'ukrainian', 'ru': 'russian'}
cursor.execute (sql, data)

执行该查询后，表中没有该记录。

如果在 SQLyog 中执行相同的查询，记录将存在。

我也试过:

sql = "INSERT INTO adr_citydistricts (CityDistrict, CityDistrictRU) VALUES ('123 ', '333');"
cursor.execute (sql)
print sql

并且表中没有行。

控制台显示:INSERT INTO adr_citydistricts (CityDistrict, CityDistrictRU) VALUES ('123', '333');

在 SQLyog 中执行此查询，通常会在表中插入一行。

我已经创建了另一个具有相同结构的表。

有人可以帮帮我吗？

Answer 1

您需要cursor.commit()以反射(reflect)变化。

9.2.3. Method MySQLConnection.commit()

This method sends a COMMIT statement to the MySQL server, committingthe current transaction. Since by default Connector/Python does notautocommit, it is important to call this method after everytransaction that modifies data for tables that use transactionalstorage engines.