How to store/insert image in mysql data base manju

preview_player
Показать описание
Make sure you are storing the image same path as mentioned in the video(Uploads folder in My SQL Server 8.0).
Рекомендации по теме
Комментарии
Автор

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 );

AnhNguyen-mttx
Автор

insert into images
values
(1, load_file('C:\\Users\\vamsh\\Documents\\Driver_imgs\\images\\driver_1.jpg')); It is showing null in output

BAADEVAMSHIBAADEVAMSHI
Автор

It's not work why u use c3 in load file

mahammadnisaruddeen