python存数据mysql_python如何把图片存到数据库mysql中

执行命令 ”vim tupian.py“ 输入以下内容创建python脚本；

#/usr/bin/python

#coding:utf-8

import pymysql

#创建连接

Connection = pymysql.connect(database='tiny', host='192.168.6.3', user='root', password='Tanli123')

cursor = Connection.cursor()

#创建存储图片的表pictures

sql_create_table = '''

create table pictures

(

id int (10),

data MediumBlob

)

'''

#执行sql语句，创建pictures表

cursor.execute(sql_create_table)

#读取图片

fp = open("/home/dog.jpg",'rb')

img = fp.read()

fp.close()

sql = "INSERT INTO pictures VALUES (%s,%s);"

args = ('1',img)

cursor.execute(sql,args)

#提交

Connection.commit()

#断开链接

Connection.close()

print("Database created successfully！！")

print("Picture uploaded successfully! !")