Upload image directly through mySQL Command Line

mysql database blob mysql-loadfile
BurninatorDor picture BurninatorDor · Dec 9, 2011 · Viewed 49.8k times · Source

I have a certain table in mySQL which has a field called "image" with a datatype of "BLOB". I was wondering if it is possible to upload an image in that field directly from the Command Line Client rather than doing it through php...If it is possible, then where exactly should I place my image files?

Answer

Bill Karwin picture Bill Karwin · Dec 9, 2011

Try using the LOAD_FILE() function.

UPDATE `certain_table`
SET image = LOAD_FILE('/full/path/to/new/image.jpg')
WHERE id = 1234;

See the manual for requirements about the path to the filename, privileges, etc.

Related questions

How to insert image in mysql database(table)?

I want to insert image into a table like CREATE TABLE XX_SAMPLE(ID INT ,IMAGE BLOB); So can you help out form how to insert image into the above table.

Read More
How to insert images in blob in mysql table using only sql syntax (without PHP)?

Hi,I am new to SQL and I wanted to store images in the database.I already created a column with blob data type and tried to execute the following statement as given here INSERT INTO `abc` (`img`) SELECT BulkColumn …

Read More
How can I store and retrieve images from a MySQL database using PHP?

How can I insert an image in MySQL and then retrieve it using PHP? I have limited experience in either area, and I could use a little code to get me started in figuring this out.

Read More