What if the mysqldb execution statement of python is invalid?

clipboard.png

clipboard.png

mysql

clipboard.png

clipboard.png

Feb.11,2022

try adding the statement cursor2.commit () to the end
if you can, you set autocommit=false


default autocommit=false, is not automatically submitted. You need to manually call the cursor2.commit () method


python/en/connector-python-api-mysqlcursor-fetchall.html" rel=" nofollow noreferrer "> https://dev.mysql.com/doc/con.

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-1b33dba-34294.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-1b33dba-34294.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?