LOADING A PDF FILE INTO A FIELD OF A TABLE AS A BLOB

[KRISHNAN SAKOTAI]

I have an existing table called tblCustomer. It has various fields. There is also a MEDIUMBLOB field called Demographics into which I want to load a pdf file called Customer_DAta.pdf from \home\data directory.

I am unable to find how to load the pdf file into the Demographics field. Any sql help is appreciated.

My further query is: As a result of a query on the table, will I be able to click on the pdf file to open it?

I am using mysql8 on a Linux platform

Thanks in advance