Statement for inserting image as blob into Sql query browser

peggie1990 · #1 (**permalink**) 07-01-09, 20:58

Hello, my name is Peggie.
Currently, I am using sql query browser as my database and I would like to insert a blob image into the database. Do we need to declare a path during the inserting of the statament? example: D:/Desktop/Beannie/10.JPG.

Coulde you guys tell what is the insert statement?
Thanks

Hope to receive ur reply soon

mike_bike_kite · #2 (**permalink**) 07-02-09, 07:49

Why not just leave the image on your file system and then just insert a link to the file ie

Code:

insert Products ( name, image_link ) 
values ( "Beanie", "D:/Desktop/Beannie/10.JPG" );

Mike

peggie1990 · #3 (**permalink**) 07-02-09, 10:25

Thanks for ur help

peggie1990 · #4 (**permalink**) 07-02-09, 10:27

Thanks for ur help

Internet Services

Web Development

Digital Marketing

Consumer Tech