0

I am tring to use a for loop to add data to a table each time with a different id which is the primary key. This is my code and the table is already created

x = 1
for x in range(20):
    c.execute("INSERT INTO yourplayers VALUES(? , 'John', 'biggs', 2, 55, 'A', 55)", (x))
    x = x+1
c.execute('SELECT * FROM yourplayers')
conn.commit
print(c.fetchall())

It comes up with the error parameters are of an unsupported type but when i get rid of the question and the x in brackets and replace it with just a number it work (if ive stopped it being a primary key or it crashes). Does anyone know what im doing wrong here. The data type where the question mark is is INT

Martijn Pieters
  • 1,048,767
  • 296
  • 4,058
  • 3,343
maxpepsi
  • 33
  • 4

0 Answers0