Sqlite Python display table at once

Question

I've made a small database program in Python using SQLite. My goal is to display all my entries that are in my table. I'm able to make that happen, but I have to hit Enter each time.

elif selection == '2': 
  print "Opened database successfully \n"
  cursor = conn.execute("SELECT * FROM DATABASE")
  all = cursor.fetchall()
  for row in all:
    print "ID = ", row[0], "NAME = ", row[1],  "CHECKED IN = ",  row[2], "\n"
    raw_input()

Is there a way I can display them all at once?

I have tired to remove the raw_input but all that does is goes back to my menu.

Put raw_input() outside your for loop.

Prerak Sola
– Prerak Sola

2015-06-08 11:51:53 +00:00
Commented Jun 8, 2015 at 11:51 — Prerak Sola
– Prerak Sola, Commented Jun 8, 2015 at 11:51

Burhan Khalid · Accepted Answer · 2015-06-08 11:52:06Z

1

The reason it stops is because you have raw_input() in your loop; you can move it out of your loop:

elif selection == '2': 
   print "Opened database successfully \n"
   cursor = conn.execute("SELECT * FROM DATABASE")
   all = cursor.fetchall()
   for row in all:
      print "ID = ", row[0], "NAME = ", row[1],  "CHECKED IN = ",  row[2], "\n"
   raw_input()

Also, please pay attention to indenting in Python it is critical.

answered Jun 8, 2015 at 11:52

Burhan Khalid

175k20 gold badges255 silver badges292 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

shaggs Over a year ago

I should have known it was something so simple. That's why an extra set of eyes are good

Collectives™ on Stack Overflow

Sqlite Python display table at once

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related