values_to_insert = [('a', 'b'), ('c', 'd')]
query = 'INSERT INTO T (F1, F2) VALUES ' + ','.join('(%s, %s)' for _ in
    values_to_insert)
flattened_values = [item for sublist in values_to_insert for item in sublist]
c.execute(query, flattened_values)
How to use python mysqldb to insert many rows at once