我正在try 从我的数据库中删除一行，但没有成功.以下是我的代码:
import mysql.connector
mydb = mysql.connector.connect(host="localhost",user="user",passwd="1",database="workers")
mycursor = mydb.cursor()
query = "DELETE FROM `workers` WHERE id = %s"
# connect to the database server
# execute the query
mycursor.execute(query, (1,))
mysql.commit() # You need to commit the transaction
注意:我使用的是python3.10，操作系统是ubuntu.我也try 使用%d而不是%s，但它不工作.
我创建了一个测试表:
mysql> select version();
+-----------+
| version() |
+-----------+
| 8.2.0 |
+-----------+
mysql> create table workers (id serial primary key);
Query OK, 0 rows affected (0.01 sec)
mysql> insert into workers values (1), (2);
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> select * from workers;
+----+
| id |
+----+
| 1 |
| 2 |
+----+
DEMO脚本DELETE-Test.py:
import mysql.connector
if __name__ == '__main__':
config = { ... }
mydb = mysql.connector.connect(**config)
mycursor = mydb.cursor()
# FIXED: use %s instead of %d
query = "DELETE FROM `workers` WHERE id = %s"
mycursor.execute(query, (1,))
# FIXED: mydb instead of mysql
mydb.commit()
mycursor.close()
mydb.close()
运行脚本:
% python3 --version
Python 3.11.4
% python3 ./delete-test.py
%
判断结果:
mysql> select * from workers;
+----+
| id |
+----+
| 2 |
+----+