Python Forum

Full Version: MySQLdb._exceptions.ProgrammingError: not enough arguments for format string.

You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Hi...I have created a button to copy data from table1 to table2. The problem is I got this error:

Error:
MySQLdb._exceptions.ProgrammingError: not enough arguments for format string

This is my code:

cur.execute("INSERT INTO table2 (id,q) WHERE id = %s SELECT id,q FROM table1 WHERE id = %s", [id])

farah97