'MYSQL image not inserting into table using BLOB and giving ERROR Column 'pict' cannot be null

create table classa( sname char(30), sdiv char(30), pict blob NOT NULL);
insert into classa values( "anil", "a", LOAD_FILE('D:/project UV/hackathon/res/ak1.jpg'));

ERROR 1048 (23000): Column 'pict' cannot be null

then i tried using backslash but still getting the same error

i am using MYSQL commanf line client and its up to date. also,the file size is merely 6Kb so blob should be okay with that.

but i dont understand, why am i getting this error .

also, i only want it done via command line client only



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source