I am getting into SQL, trying to insert a value into a specific table column but it seems it only wants to take one character compared to the entire string I am attempting to supply it.
import sqlite3
import random
conn = sqlite3.connect(r"test.db")
cursor = conn.cursor()
profile_ID = str(random.randint(100,999))
'''
insert into one column
'''
cursor.execute("INSERT INTO Webstore(Running) VALUES(?)", (profile_ID))
this is the error that appears:
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 3 supplied.
It seems the insert with the query above only wants to accept one character versus the three in profile_ID, I attempt to send a string such as "string 6" and it would pass me the same error but "8 supplied" in this case (8 characters in "string 6").