How to drop a sqlite table in python according to a variable name passed through a function

Question

def refreshDatabase(table):
    
    c.execute("DROP TABLE ?", (table,))
        
    conn.commit()

    createNewTable(table)

Hey, how can I drop the Table that is declared as a parameter when calling the function? It doesn't seem to work with this syntax. thanks in advance!

This is the error message I get: c.execute("DROP TABLE ?", (table,)) sqlite3.OperationalError: near "?": syntax error — JannesEbeling, Apr 12 '22 at 22:14

score 0 · Answer 1 · answered Apr 13 '22 at 01:42

0

Take a look here

You can't substitute table name at SQL side, so change it from Python (which is not safe of course)

def refreshDatabase(table):
    c.execute(f"DROP TABLE {table}")
    conn.commit()
    createNewTable(table)

answered Apr 13 '22 at 01:42

Alex Kosh

Please don't answer if the question has been answered elsewhere - just flag as a duplicate (as you did). – snakecharmerb Apr 13 '22 at 05:20

1 Answers1