import mysql.connector
def gravar(self,dado):
cursor = self.__mysql_connection.cursor()
sql = """
INSERT INTO ras_relatorio_evento
(ras_rle_id_veiculo ,ras_rle_contador ,ras_rle_data ,ras_rle_data_coleta ,ras_rle_id_indice)
VALUES %s;
"""
insert = (",".join('({} ,{} ,{},{} ,{})'.format(a, b, c, d, e) for (a, b, c, d, e) in dado))
print(insert)
insert = "(9733,13,'2020-05-27','2020-05-28 13:50:15.288763',4794),(9883 ,15 ,'2020-05-27','2020-05-28 17:31:52' ,4794)"
cursor.execute(sql,(insert,))o codigo esta com poucos exemplos de dados mas por vez seria inserido mas de 200 dados e eu precisaria usar uma string formada ja pra passar os dados mas recebo esse erro
mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''(9733 ,13 ,2020-05-27,2020-05-28 17:31:52 ,4794),(9851 ,13 ,2020-05-27,2020-05-' at line 3
