print('Les restaurants de la ville de Marseille :') cursor.execute(""" SELECT id, nom FROM restaurants WHERE ville = %s""", ("Marseille", )) for row in cursor: print('{0} : {1}'.format(row[0], row[1]))