Cannot insert data in mysql-database: 'ValueError: Could not process parameters'

Question

I have a list like this:

prices= ['$22,999', '$7,499', '$33,000', '$6,000', '$34,600', '$8,999', '$6,200', '$7,975']

I want to insert this list to database like this:

sql = "INSERT INTO abc (a) VALUES (%s)"
mycursor.executemany(sql, prices)

but I get error, why?

 ValueError: Could not process parameters

Does this answer your question? MySQL Connector could not process parameters — Maurice Meyer
– Maurice Meyer, Commented Nov 15, 2021 at 8:09
I think you must transform the prices to an array of tuples of one element. — Ptit Xav
– Ptit Xav, Commented Nov 15, 2021 at 8:15
You are trying to input string value into SQL, is your SQL column type is string or numeric? — Rizquuula
– Rizquuula, Commented Nov 15, 2021 at 8:20

Ptit Xav · Accepted Answer · 2021-11-15 08:19:00Z

0

Transform list to list of tuples :

pricesTuples = [(p,) for p in prices]

answered Nov 15, 2021 at 8:19

Ptit Xav

3,2272 gold badges10 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1