我正在尝试编写一个函数,该函数placeholder()采用下面编写的函数中编写的变量,然后在 MySQL 查询中使用该变量。我在下面写了一个例子:
placeholder()
import MySQLdb connection = MySQLdb.connect(host = "localhost", user = "root", passwd = "", db = "cars") cursor = connection.cursor() def placeholder(placeholder_variable): sql = "TRUNCATE TABLE %s" cursor.execute(sql, placeholder_variable) placeholder('car_brands')
当我尝试运行该程序时,出现以下错误:
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''car_brands'' at line 1")
这是用于大学作业,必须使用placeholder('variable')格式来接收变量。我花了数小时在互联网上搜索,试图找到解决方案,请帮助:/
placeholder('variable')
sql = "TRUNCATE TABLE " + placeholder_variable + ";" cursor.execute(sql)