Why can I still insert null values when not null, is set in mysql?

Table structure

clipboard.png

Feb.27,2021

this is an empty string "", unlike null


mysql.ini file
sql-mode= "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
change to
sql-mode= "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
, an error will occur

in fact, this is mysql to help you convert null into'

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