How To Store Images In MySQL Database Using Python

In this video we will be learning how to store images in a MySQL database and retrieve them using Python

[fernandoalbertodelatorrega]

You literally saved my final project for Software Engineering. Thanks a lot mate!

[exploseph]

Great tutorial, straight to the point and clear explanations the whole way. This helped me get image storage working for my project. Thanks a ton!

[douglasleece]

Thanks for posting this, it was very much inline with something I needed to build. I quite like how you broke the file handling tasks into two functions.

[mustafabohra]

Learnt so many things in a single video. Thanks man!

[mission_and_purpose]

Thank you very much! that helped me a lot.

[quotcode]

Great explanation man. Thanks a lot. I wish you all the best and you will surely get a lot of susbcribers soon.

Keep posting such videos.
Support from Mumbai, India : )

[PythonDevelopment]

Thanks, colleague. ) Like, subscribe and look forward to more new materials

[jholl]

This video was amazing and short. do you have a video where you do this in java? with MariaDB.

[joaopedra]

Thank you for the video! How can you store more than only one image at a time

[oveyo]

On the RetrieveBlob function I'm getting this error: UnincodeDecoderError: 'utf-8' codec can't decode byte 0xff in position 0: invalid start byte

[TheHundi]

Isn't using format strings bad? Because you become vulnerable to SQL injection

[fatmagad]

can you help me with changes if I'm using flask?
I'm using the following code and it never works, I can't define where the mistake is and I'm 100% sure of every variable's name!!!


@app.route('/AddImage', methods=['GET', 'POST'])
def AddImg():
if request.method == 'POST':
if request.files:
imgdata = request.files ['imgdata']


sql = "INSERT INTO images (imgdata) VALUES (%s)"
mycursor.execute(sql, (imgdata, ))
mydb.commit()
return render_template('AddImage.html', msg='photo saved')
else:
return

[amaytripathi]

getting error while retrieving image only byte like object required

[kbrcompilation]

Sir how to display that image from mysql using python tkinter if i search the Id.

[enesuqur]

You can find the version for SQL database below.