Shulou(Shulou.com)05/31 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.