how to extract an image from the SQL database ?

Question

import the image from the database to use it in my tkinter gui.

Answer 1

There isn't going to be a short answer for this. So, I'm just going to send you a couple of links that should get you started.

https://pynative.com/JUMP_LINK__&&__python__&&__JUMP_LINK-mysql-blob-insert-retrieve-file-image-as-a-blob-in-mysql/

https://stackoverflow.com/questions/8317421/retrieve-and-displaying-blob-images-from-mysql-database-with-tkinter?rq=1

Answer 2

You can store images and other binaries as BLOB datatypes. These could also be stored as base 64 encoded strings.

https://dev.mysql.com/doc/refman/8.0/en/blob.html

Answer 3

Im just curious why not to save path to image into table field?

Answer 4

we need to know How did you store the image?

Answer 5

David Carroll thanks for your answer but i don't have problem in saving the picture to the database the problem arises when i want to show the picture which I've saved in database..help me to how to do it..