Displaying all records of Blob images in Tkinter

1. Displaying all records of MySQL table with photo ( Blob data type )
2. Uploading and inserting image data to Blob column of MySQL table
3. Listing the record with all details based on user selection.
4. Updating Blob data by uploading new image
5. Deleting record with Blob data

About MySQL table student_profile.

CREATE TABLE `student_profile` (
  `id` int NOT NULL,
  `student` varchar(10) NOT NULL,
  `profile_photo` longblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
COMMIT;

CREATE TABLE IF NOT EXISTS student_profile(id integer,
	student text,profile_photo blob);

Displaying record details with Photo

my_conn = create_engine("mysql+mysqldb://userid:password@localhost/database_name")
my_row=my_conn.execute("SELECT * FROM student_profile limit 0,4")
for student in my_row:
	pass

    e = Label(my_w, text=student[0]) 
    e.grid(row=i,column=1,ipadx=20) 
    e = Label(my_w, text=student[1]) 
    e.grid(row=i,column=2,ipadx=60) 

import io
from PIL import Image, ImageTk

    stream = io.BytesIO(student[2])
    img=Image.open(stream)
    img = ImageTk.PhotoImage(img)    
    e = Label(my_w, image=img) 
    e.grid(row=i, column=3,ipady=7)
    images.append(img) # garbage collection 

import tkinter  as tk 
from tkinter import * 
from sqlalchemy import create_engine
import io
from PIL import Image, ImageTk
my_w = tk.Tk() # parent window 
my_w.geometry("400x500") # size as width height
my_w.title("www.plus2net.com")  # Adding a title
# database connection 
my_conn = create_engine("mysql+mysqldb://userid:password@localhost/database_name")
my_row=my_conn.execute("SELECT * FROM student_profile limit 0,4")

# Column headers  row 0
l1=Label(my_w, text='ID') 
l1.grid(row=0,column=1) 

l2=Label(my_w, text='Name') 
l2.grid(row=0,column=2) 

l3=Label(my_w, text='Photo') 
l3.grid(row=0,column=3) 

i=1 # data starts from row 1 
images = [] # to manage garbage collection. 

for student in my_row: 
    stream = io.BytesIO(student[2])
    img=Image.open(stream)
    img = ImageTk.PhotoImage(img)    
    e = Label(my_w, text=student[0]) 
    e.grid(row=i,column=1,ipadx=20) 
    e = Label(my_w, text=student[1]) 
    e.grid(row=i,column=2,ipadx=60) 
    e = Label(my_w, image=img) 
    e.grid(row=i, column=3,ipady=7)  
    images.append(img) # garbage collection 
    i=i+1    
my_w.mainloop()

Deleting record