基于python的图片和个人信息从mysql数据库中存取。

1.图片存入mysql数据库

import pymysql
path = "./mysql/10.jpg"
filename = path.split(/)[-1]
with open(path, rb) as f:
    img = f.read()
    print(type(img))
conn = pymysql.connect(host=localhost,
                       port=3306,
                       user="root",
                       passwd=,
                       db="images",
                       charset=utf8,
                       use_unicode=True)
cursor = conn.cursor()
sql = "INSERT INTO images (data, name) VALUES (%s, {0})".format(filename)
cursor.execute(sql, img)
conn.commit()
cursor.close()
conn.close()
print(写入 {} 成功.format(filename))

2.从mysql数据库取出图片

import pymysql
path = "./mysql/read.jpg"
filename ="10.jpg"
conn = pymysql.connect(host=localhost,
                       port=3306,
                       user="root",
                       passwd=,
                       db="images",
                       charset=utf8,
                       use_unicode=True)
cursor = conn.cursor()
cursor.execute("select data from images where name = {}".format(filename))
res = cursor.fetchone()[0]
with open(path, wb) as f:
    f.write(res)
print(从数据库中读取 {} 成功.format(filename))

3.存入个人信息到mysql数据库

import pymysql
conn = pymysql.connect(host=localhost,
                       port=3306,
                       user="root",
                       passwd=,
                       db="images",
                       charset=utf8,
                       use_unicode=True)
cursor = conn.cursor()

# 注意一下这里的 {0} 的引号，可以试一下去掉引号会提醒没有者找到该字段
x=input("输入英文名：")
y=input("输入中文名：")
w=input("输入邮箱：")
h=input("输入电话号码：")
parme=[x,y,w,h]
sql = "INSERT INTO information (yname, name,email,telephone) VALUES (%s,%s,%s,%s)"
cursor.execute(sql,parme)
conn.commit()
cursor.close()
conn.close()
print(写入成功)

4.从mysql数据库提取个人信息

import pymysql
conn = pymysql.connect(host=localhost,
                       port=3306,
                       user="root",
                       passwd=,
                       db="images",
                       charset=utf8,
                       use_unicode=True)
cursor = conn.cursor()

sql = "select name from information"
cursor.execute(sql)
print(cursor.fetchall())
conn.commit()
cursor.close()
conn.close()
print(导出成功)