whenever i try to add a list into the mysql table I get an error : 'ProgrammingError: Not all parameters were used in the SQL statement'

ive tried to look online but all i could found is that i need to use %s to solve this and not any other type of placeholders but i alredy do..

my code (just mentioning that i have like 20 name in that list, but i dont think it really matters):

mydb=mysql.connector.connect(host='localhost',user=d,passwd=z,database=y)
listname=['name1','name2','name3','name4']
mycursor=mydb.cursor()
mysqlcommand='INSERT INTO tabletest (firstname) values (%s)'
mycursor.executemany(mysqlcommand,listname)

thank you!

The second argument to executemany must be a sequence of sequences or mappings, i.e.

listname=[('name1',), ('name2',), ('name3',), ('name4',)]

See https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-executemany.html:

This method prepares a database operation (query or command) and executes it against all parameter sequences or mappings found in the sequence seq_of_params.