Description
The LOAD_FILE( ) function reads and returns the file constants as a string.
This function has the form:
SELECT LOAD_FILE(file_name)| Parameter | Description |
|---|---|
| file_name | A file name |
Return Value
The file constants as a string.
Examples
The following example shows the basic use of this function:
mysql> UPDATE t
SET blob_col=LOAD_FILE('/tmp/picture')
WHERE id=1;