sql - How to insert a file in MySQL database?

Question

I want to insert a file in MYSQL database residing on a remote webserver using a webservice.

My question is: What type of table column (e.g. varchar, etc.) will store a file? And will the insert statement be somewhat different in case of a file?

Answer 1

The BLOB datatype is best for storing files.

• See: How to store .pdf files into MySQL as BLOBs using PHP?
• The MySQL BLOB reference manual has some interesting comments