MySQL требует значения по умолчанию для столбца Blob ⇐ MySql

[Anonymous]

Это моя таблица, и я хочу вставить в него изображение, но я получаю ошибку «Поле« хранение »не имеет значения по умолчанию»
mysql doc говорит, что Blob не хочет значения дефолта
mysql> show columns from cover;
+----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+----------------+
| idx | smallint | NO | | NULL | |
| nomefile | varchar(255) | YES | | NULL | |
| sizefile | varchar(255) | YES | | NULL | |
| mimetype | varchar(255) | YES | | NULL | |
| storing | blob | NO | | NULL | |
| id | smallint | NO | PRI | NULL | auto_increment |
+----------+--------------+------+-----+---------+----------------+
6 rows in set (0,01 sec)

def add_image(self, idx):
options = QFileDialog.Options()
options |= QFileDialog.DontUseNativeDialog
fileName, _ = QFileDialog.getOpenFileName(self, "Open Image", "/media/hdb1/", "Images (*.png *.xpm *.jpg)", options=options)
query = "SELECT * FROM `cover` WHERE idx = %s " % (idx)
if fileName:
#This is just in case you need to manually delete the row in the table 'cover'
conn, cursor = Functions.openDB(self, dbname)
cursor.execute(query)
nbrrows = cursor.rowcount
if nbrrows == 0:
query = "INSERT INTO `cover` (idx) VALUES (%s)" %(idx)
И это ошибка, которую я получаю < /p>
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/mysql/connector/connection_cext.py", line 661, in cmd_query
self._cmysql.query(
_mysql_connector.MySQLInterfaceError: Field 'storing' doesn't have a default value

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Projects/personal/library_read.py", line 259, in
image_btn.clicked.connect(lambda connect: self.add_image(idx))
File "/Projects/personal/library_read.py", line 299, in add_image
cursor.execute(query)
File "/usr/local/lib/python3.10/dist-packages/mysql/connector/cursor_cext.py", line 374, in execute
result = self._cnx.cmd_query(
File "/usr/local/lib/python3.10/dist-packages/mysql/connector/opentelemetry/context_propagation.py", line 74, in wrapper
return method(cnx, *args, **kwargs)
File "/usr/local/lib/python3.10/dist-packages/mysql/connector/connection_cext.py", line 669, in cmd_query
raise get_mysql_exception(
mysql.connector.errors.DatabaseError: 1364 (HY000): Field 'storing' doesn't have a default value


Подробнее здесь: https://stackoverflow.com/questions/796 ... lob-column