print('Tous les enregistrements :') cursor.execute(""" SELECT id, nom, ville FROM restaurants""") for row in cursor: print('{0} : {1}, {2}'.format(row[0], row[1], row[2]))