mysql insert syntax for blob data through Stored procedure

Question

Hi All,

I want to insert an img file in mysql database, can anyone provide normal insert statement for inserting blob into mysql database. How i can do it as if i specify the path it stores the path only not the img

Answer 1

Try the LOAD_FILE() function.