Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    1

    Unanswered: load binary file into table

    i would like to insert a binary file into a table. i know that most people think that it is more efficient just to store the directory path of the file in the db. anyway, i created a blob column but don't know what the mysql command line command to load a binary file into a table is? just didn't find anything about it in the mysql doc!

    thanks for any help!!!

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    You can use LOAD_FILE() function

    UPDATE table_name
    SET blob_column=LOAD_FILE('pathto binary file');
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

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