insert into imgTest values(1,'first',load_file('C:/Users/New folder/Desktop/4.png')); This is my query.When I am trying to insert image there is an error - Error Code: 1048. Column 'img' cannot be null. How can I solve this. create table slide ( id bigint not null primary key auto_increment, pic longblob not null );
insert into images values (1,load_file('C:\\Users\\vamsh\\Documents\\Driver_imgs\\images\\driver_1.jpg')); It is showing null in output
same
audio is terrible
thanks the best
kya baat hai..it works well
It's not work why u use c3 in load file
c3 is his image name/file name
its not working
insert into imgTest values(1,'first',load_file('C:/Users/New folder/Desktop/4.png')); This is my query.When I am trying to insert image there is an error - Error Code: 1048. Column 'img' cannot be null. How can I solve this. create table slide ( id bigint not null primary key auto_increment, pic longblob not null );
Uncheck the NN for the blob datatype, your error occurs when the img column does not have any image uploaded
Change the slash / to \
Thank you for sharing.