Python reports an error when storing picture binaries in mysql

with open("face.jpg","rb") as f:
    img_data=f.read()
find_binary=pymysql.Binary(img_data)
print(find_binary)
add_row="""INSERT INTO IMGS(ID,IMG,,DATAIMG) VALUES(7,"K1","NO.","%s")""" % (find_binary)
cursor.execute(add_row)

here are the reasons for the error

pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "\\xff\\xd8\\xff\\xe0\\x00\\x10JFIF\\x00\\x01\\x01\\x01\\x00H\\x00H\\x00\\x00\\xff\\xdb\\x00C\\x00\\" at line 1")

seems to be grammatical or the output of pymysql.binary is not a binary file at all, but it is not clear what went wrong, and the DATAIMG type is mediumblob

Mysql python

May.06,2021

SQL manipulating string concatenation is not a good habit. Try parameterized query:

find_binary=pymysql.Binary(img_data)
add_row = """INSERT INTO IMGS(ID,IMG,,DATAIMG) VALUES($s, %s, %s, %s)"""
cursor.execute(add_row, (7, 'K1', 'NO.', find_binary))

Previous: How to query the foreign keys of which tables are the primary keys of a table in mysql

Next: The @ Slf4j, method is used but log does not have an info method

Modification of database by sqlalchemy
engine = create_engine ( "mysql+pymysql: root:111@localhost xxx ", encoding= utf-8 , echo=True) Session_class = sessionmaker (bind=engine) Session = Session_class () modify a record user = Session.query (User). Filter_by (id=1). First () user.n...

Sqlalchemy mysql python

Mar.02,2021
What's wrong with pymysql import?
...

Mysql python

Mar.06,2021
How to solve the problem that the string numbers are saved in the database and all of them are killed from the front to the zero?
some data are like this: 1186486, 0215648, 00064876, mysql stores data to columns of char type, data is stored in front of 0, all columns are killed. How to solve the short ones are preceded by 0, and the data is a string in python and does not ki...

Pymysql python mysql

Mar.07,2021
Python connected to mysql successfully. After executing the insert command, there is no value in the table in mysql.
first of all, I created a database, called dd in mysal, and then I created a table, called books in it, and then I executed the following command in python, hoping to insert a value in books: < hr > import pymysql conn=pymysql.connect (host= "127....

Mysql python

Mar.07,2021
Pymysql inserts a numeric string into the database and does not report an error and does not successfully ask for help.
insert but the data is a number, which is stored in the database as a string, and the corresponding field in the database is also of string type The python statement goes like this: sql = insert into uhaoma343 (riqi,uhaoma) values({},{}) .format(r...

Pymysql python3.x python

Mar.09,2021
Python3.6 installation MySQL-python-1.2.5 error
python: 3.6 mysql: 8.0 Boss, how to solve ...

Mysql python

Mar.11,2021
How to connect jmeter or python to mysql? on the springboard
at present, the company s mysql database cannot be connected directly locally and needs to be connected through a springboard (windows server). The steps to manipulate the data each time are: connect the springboard machine (windows server,ip: 10.*...

Mysql python jmeter

Mar.11,2021
Mysql insert field error
I put keywordpackagename: in this table. ...

Mysql python

Mar.12,2021
How to solve the error report in mysql
z how to solve this problem ...

Mysql python

Mar.12,2021
I would like to ask you how a given address can be divided into separate administrative divisions of provinces, cities and regions. I have been thinking about it all day without any ideas.
ask for help from seniors: if the long address is xxxx, Nanjing Road, Heping District, Tianjin how can it be dealt with by means of no manual intervention: Tianjin; Heping District; Nanjing Road; this kind of administrative division? because the inp...

Java php javascript mysql python

Mar.13,2021
Error in pycharm connection mysql database execution file under OS environment
python version is 3.5, MySQL version is 5.7.21, create database: py4e create table: PymySqlTest, install pymysql pip3 install pymysql prompt Requirement already satisfied: pymysql in Library Frameworks Python.framework Versions 3.7 lib python3.7...

Mysql python

Mar.16,2021
There is a problem with writing txt documents to MySQL database with python.
the contents of the txt document are as follows: - supplementary question. The code is improved as follows, but still encounter problems: import mysql.connector conn = mysql.connector.connect(host= localhost , port=3306, user= root , password= ...

Mysql python

Mar.16,2021
During rabbit asynchronous processing, mysql read an unfinished data and reported an error.
Application scenario: the client uploads the file and the django server writes a piece of status=1 data in the database. Then give it to rabbit to read the file and parse it. After parsing, set status to 2. The transmission format of rabbitmq is { "f...

Django rabbitmq mysql python

Mar.18,2021
Clustering of Python- large-scale trajectory data
recently, I have been working on track data clustering. Now I have track data of about 2 million people on hand. Each person s track consists of a sequence of points (a point position every half hour), as shown in the table . A day is divided int...

Mysql python

Mar.20,2021
Why does pymysql update the database with a total prompt of 1054?
sql = "UPDATE arms SET gem2= %s WHERE id = ( %d )" % ( ,new_id) (1054, "Unknown column gem2 in field list ") sql = "UPDATE arms SET gem2= WHERE id = ( %d )" % new_id (1054, &quo...

Pymysql python mysql

Apr.05,2021
Python redis is used for caching. Redis hset fails when data is entered into mysql.
problem description when I use python3 s redis for caching, the structure is hset, but when the data reaches 10000, I need to store these 10000 pieces of data into the database. When I delete the hset, of redis, the new request is not added to the re...

Mysql python redis

May.31,2021
Optimization of mysql in the case of continuous concurrent writes
Business scenario 7pm 24-hour continuous data writing and updating (market system), it is necessary to store the transaction record and update the k line after calculating the k line according to the transaction record current solution use Celery ...

Mysql python

Jun.07,2021
Python3 pymysql has been confused.
import pymysql import time import datetime -sharp db = pymysql.connect("localhost","root","aaaaaa","getlist" ) cursor = db.cursor() sql="INSERT INTO t_mall VALUES (0,%s,%s,%s)" try: -sharp SQL curs...

Mysql python

Jul.08,2021
How to set up a foreign key foreignkey in sqlalchemy can be associated with your own table, such as comment related reply, comment and reply all belong to Comment
problem description the environmental background of the problems and what methods you have tried related codes Please paste the code text below (do not replace the code with pictures) class Comment (Model): """ comment and re...

Mysql python

Jul.21,2021
Python crawl data is written to mysql error pymysql.err.ProgrammingError: Cursor closed
for loop write crawl to crawl data, and then write mysql, to look at the database, the write is successful, but reported an error, may I ask why? ...

Mysql python

Jul.27,2021

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1ea5740-47b1f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1ea5740-47b1f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?