python3.x - python mysql executemany提取数据问题

Question

从mysql中提取数据，stocklist长度是300，executemany是283,fetchmany只返回了一个值，求问该怎么解决。。

Answer 1

I solved it myself, using select in, but this returns 283 pieces of data, which cannot be aligned with the stocklist. I don’t know if there is any way to solve it