pythonopencv 拍摄_用Python和OpenCV将拍摄到的图像存储到MySQL数据库中

我这里有一段代码，可以从笔记本电脑的内部网络摄像头捕捉图像。我想把我的图片直接发送到MySQL数据库。这是密码。在import numpy as np

import cv2

import mysql.connector

from mysql.connector import errorcode

from time import sleep

import serial

# Obtain connection string information from the portal

config = {

'host':'oursystem.mysql.database.azure.com',

'user':'user',

'password':'pass',

'database':'projectdb'

}

try:

conn = mysql.connector.connect(**config)

print("Connection established")

except mysql.connector.Error as err:

if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:

print("Something is wrong with the user name or password")

elif err.errno == errorcode.ER_BAD_DB_ERROR:

print("Database does not exist")

else:

print(err)

cursor = conn.cursor()

cursor.execute("CREATE TABLE if not exists Camera (img BLOB);")

cap = cv2.VideoCapture(0)

# Check if the webcam is opened correctly

if not cap.isOpened():

raise IOError("Cannot open webcam")

frame = cap.read()[1]

cursor.execute("INSERT INTO Camera (img) VALUES %s",frame)

cap.release()

正如你们所看到的，我试图直接将捕捉到并存储在变量'frame'中的图像发送到我的数据库中，但它不起作用。有什么想法吗？在