Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009
    Posts
    10

    Unanswered: Statement for inserting image as blob into Sql query browser

    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

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    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

  3. #3
    Join Date
    Jun 2009
    Posts
    10

    Re database

    Thanks for ur help

  4. #4
    Join Date
    Jun 2009
    Posts
    10
    Thanks for ur help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •