基于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('导出成功')