I’m trying to loop through an array and insert each element into a table. As far as I can see my syntax is correct and I took this code straight from Microsoft Azure’s documentation.
try: conn = mysql.connector.connect(**config) print("Connection established") except mysql.connector.Error as err: if err.errno == errorcode.ER_ACCESS_DENIED_ERROR: print("Something is wrong with the user name or password") elif err.errno == errorcode.ER_BAD_DB_ERROR: print("Database does not exist") else: print(err) else: cursor = conn.cursor() data = ['1','2','3','4','5'] for x in data: cursor.execute("INSERT INTO test (serial) VALUES (%s)",(x)) print("Inserted",cursor.rowcount,"row(s) of data.") conn.commit() cursor.close() conn.close() print("Done.")
When I run this is gets to
cursor.execute(...) and then fails. Here is the stack trace.
Traceback (most recent call last):
File “test.py”, line 29, in
cursor.execute(“INSERT INTO test (serial) VALUES (%s)”,(“test”))
File “C:UsersAlexJAppDataLocalProgramsPythonPython37libsite-packagesmysqlconnectorcursor_cext.py”, line 248, in execute
prepared = self._cnx.prepare_for_mysql(params)
File “C:UsersAlexJAppDataLocalProgramsPythonPython37libsite-packagesmysqlconnectorconnection_cext.py”, line 538, in prepare_for_mysql
raise ValueError(“Could not process parameters”)
ValueError: Could not process parameters
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
for x in data: value = "test" query = "INSERT INTO test (serial) VALUES (%s)" cursor.execute(query,(value,)) print("Inserted",cursor.rowcount,"row(s) of data.")
Since you are using mysql module,
cursor.execute requires a sql query and a tuple as parameters
Nice answer from @lucas, but maybe this help other, cz i think more cleaner
sql = "INSERT INTO your_db (your_table) VALUES (%s)" val = [("data could be array")] cursor = cnx.cursor() cursor.execute(sql, val) print("Inserted",cursor.rowcount,"row(s) of data.") cnx.commit() cnx.close()
Cz this is useful for my purpose, to input multiple data.