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

Thread Rating:

Thread Modes

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

farah97
Programmer named Tim

Posts: 8

Threads: 5

Joined: Dec 2019

Reputation: 0

Jan-22-2020, 03:49 AM

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

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Set string in custom format	korenron	4	1,098	Jan-16-2023, 07:46 PM Last Post: mutantGOD
	Format String	NewPi	2	948	Oct-10-2022, 05:50 PM Last Post: NewPi
	Passing string functions as arguments	Clunk_Head	3	1,255	Jun-15-2022, 06:00 AM Last Post: Gribouillis
	mysql.connector.errors.ProgrammingError: Failed processing format-parameters; Python	ilknurg	3	5,628	Jan-18-2022, 06:25 PM Last Post: ilknurg
	TypeError: not enough arguments for format string	MaartenRo	6	2,936	Jan-09-2022, 06:46 PM Last Post: ibreeden
	string format challenge	jfc	2	1,787	Oct-23-2021, 10:30 AM Last Post: ibreeden
	Print first day of the week as string in date format	MyerzzD	2	2,021	Sep-29-2021, 06:43 AM Last Post: MyerzzD
	string.format() suddenly causing errors with google drive API	zwitrader	0	1,769	Jun-28-2021, 11:38 PM Last Post: zwitrader
	String to Date format	SAF	2	2,469	Apr-06-2021, 02:09 PM Last Post: snippsat
	Accepting strings as arguments when slicing a string? (Ziyad Yehia on Udemy)	Drone4four	4	3,793	Aug-23-2019, 07:59 PM Last Post: Drone4four

Users browsing this thread: 2 Guest(s)