Python-插入数据库表

Question

我有一个变量，我想将其值插入到我的数据库表中。我有这个，但不起作用:

import mysql.connector
import statistics
idk = []
mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  passwd="",
  database="python"
)

mycursor = mydb.cursor()

mycursor.execute("SELECT `First Name` FROM employees")

myresult = mycursor.fetchall()

for x in myresult:
    idk.append(x)

y = statistics.mode(idk)
f = '( ,)'.join(y)

print(f)

mycursor.execute("INSERT INTO results (`First Name`) VALUES (%s)", f)

mydb.commit()

我收到此错误:

mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%s)' at line 1

Answer 1

谢谢，我已经找到答案了。我只需要在 [] 中输入 f 即可。

import mysql.connector
import statistics
idk = []
mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  passwd="",
  database="python"
)

mycursor = mydb.cursor()

mycursor.execute("SELECT `First Name` FROM employees")

myresult = mycursor.fetchall()

for x in myresult:
    idk.append(x)

y = statistics.mode(idk)
f = '( ,)'.join(y)

print(f)

mycursor.execute("INSERT INTO results (`First Name`) VALUES (%s)", [f])

mydb.commit()