How to use LOAD_FILE() function in MySQL
How do I use the LOAD_FILE () function in MySQL? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something.
In MySQL, the LOAD_FILE () function reads a file and returns its contents as a string.
Grammar
LOAD_FILE (file_name)
Where file_name is the full path to the file.
Here is an example of what I selected from a file:
SELECT LOAD_FILE ('/ data/test.txt') AS Result
Results:
+-+
| | Result |
+-+
| | This text is all that the file contains! |
+-+
An example of a database
The following is an example of a query when the contents of a file are inserted into a database:
INSERT INTO MyTable (FileId, UserId, MyBlobColumn)
VALUES (1,20, LOAD_FILE ('/ data/test.txt'))
In this example, the column MyBlobColumn has a BLOB data type that allows it to store binary data.
Now that it's in the database, we can select it:
SELECT MyBlobColumn
FROM MyTable
WHERE UserId = 20
Results:
+-+
| | MyBlobColumn |
+-+
| | This text is all that the file contains! |
+-+
If the file does not exist, return NULL:
SELECT LOAD_FILE ('/ data/oops.txt') AS Result
Results:
+-+
| | Result |
+-+
| | NULL |
+-+
Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.
