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!!!

You can use LOAD_FILE() function

UPDATE table_name
SET blob_column=LOAD_FILE('pathto binary file');