mysql - MySQL中的函数 'load_file()'是否必须使用来自服务器的路径？

Question

这是我目前唯一可以在 MySQL 中使用 load_file() 函数的路径:

 C:\ProgramData\MySQL\MySQL Server 8.0\Uploads

我不能从任何其他路径附加任何其他文件吗？

因为我只能从上述路径附加 BLOB 文件附件。但是附加来自 \Desktop 或其他地方的路径.. 将值显示为 null。

这个可以修改吗？如果是，怎么办？

Answer 1

https://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_load-file

Reads the file and returns the file contents as a string. To use this function, the file must be located on the server host, you must specify the full path name to the file, and you must have the FILE privilege. The file must be readable by all and its size less than max_allowed_packet bytes. If the secure_file_priv system variable is set to a nonempty directory name, the file to be loaded must be located in that directory.