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 );
Thank you for sharing.
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 \
insert into images
values
(1,load_file('C:\\Users\\vamsh\\Documents\\Driver_imgs\\images\\driver_1.jpg')); It is showing null in output
same
kya baat hai..it works well
thanks the best
audio is terrible
its not working
It's not work why u use c3 in load file
c3 is his image name/file name