python数据库查询怎么用变量_在MySQL查询中使用Python变量

I am trying to write a function that takes the variable written in the function placeholder() written below and then uses that in MySQL queries. I have written up an example below:

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')

When I try to run this program I get the following error:

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")

This is for a university assignment and MUST use the placeholder('variable') format to receive the variable. I have spent literally hours searching the internet trying to find a solution to this please help :/

解决方案sql = "TRUNCATE TABLE " + placeholder_variable + ";"

cursor.execute(sql)