Mysql.connector.errors.programmingerror: Failed Processing Format-parameters;python 'list' Cannot Be Converted To A Mysql Type

I am trying to store some data in MYSQL database using python script, but i got the following error. mysql.connector.errors.ProgrammingError: Failed processing format-parameters;

Solution 1:

Although I never used it from what I saw:

smeData = "INSERT INTO `rob-tabl` (`time.val`,`time.microsec`,`temp.degrees`, `humid.calc`,`pressure.calc`) VALUES (%s,%s,%s,%s,%s)"
cursor.executemany(smeData, data_array)

whithout the for loop.