我有一个这样的列表:
prices= ['$22,999', '$7,499', '$33,000', '$6,000', '$34,600', '$8,999', '$6,200', '$7,975']我想像这样将这个列表插入到数据库中:
sql = "INSERT INTO abc (a) VALUES (%s)"
mycursor.executemany(sql, prices)但是我得到了错误,为什么?
ValueError: Could not process parameters发布于 2021-11-15 08:19:00
将列表转换为元组列表:
pricesTuples = [(p,) for p in prices]https://stackoverflow.com/questions/69970921
复制相似问题