'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 |
|---|
