Скачать или смотреть Display ten records of student table of MySQL database on Tkinter window using SELECT & LIMIT Query

https://www.plus2net.com/python/tkint...
We will fist connect to MySQL database by using SQLAlchemy. We are using our sample student table of my_tutorial database. Using our login details we will generate the connection string.

Our query is here
SELECT * FROM student LIMIT 0,10
Using this query we will execute the connection string and get the record set with 10 rows of records. After getting records we will display by using a for loop. We will use two for loops , one loop for each row ( outer loop ) and another for each column ( inner loop ) ,
We will use one Entry widget to display data inside the cell. We will use our looping variables to decide the rows and columns of the Entry widget.
r_set=my_conn.execute("SELECT * FROM student limit 0,10")
i=0
for student in r_set:
for j in range(len(student)):
e = Entry(my_w, width=10, fg='blue')
e.grid(row=i, column=j)
e.insert(END, student[j])
i=i+1
my_w.mainloop()

   • Displaying MySQL records & adding border w...  

Part 2 about edit and update records :    • Tkinter  to display MySQL table records an...  
Part 3 about deleting with confirmation message :    • Tkinter GUI to display MySQL table records...