LOAD_FILE() FUNCTION in MySQL

LOAD_FILE() FUNCTION The MySQL LOAD_FILE function is used to get the content of the specified file.

Syntax:

LOAD_FILE (file_name);

Parameters: file_name: It is used to specify the name of the file to read.

Example:

mysql> Update stud_table set img = LOAD_FILE('E:\file.jpg');  

Output:

Query OK, 3 rows affected (1.01 sec)
Please follow and like us:
Content Protection by DMCA.com