将文件内容插入MySQL表的列 [英] Insert file contents into MySQL table's column

问题描述

我知道有LOAD DATA INFILE语句，它使我可以将结构化数据插入表中.

I know there's the LOAD DATA INFILE statement, which allows me to INSERT structured data into a table.

我很好奇的是，是否有可能将文件内容插入到单列中.所以，是这样的:

What I'm curious about, is whether it is possible to INSERT contents of a file into single column. So, is something like this:

INSERT INTO my_table (stamp, what) VALUES (NOW(), LOAD DATA INFILE 'my_file');

可能吗?

推荐答案

是的.您可以使用 LOAD_FILE() 功能:

Yes it's possible. You can use the LOAD_FILE() function:

CREATE TABLE my_table (stamp datetime, what text);

INSERT INTO my_table (stamp, what) VALUES (NOW(), LOAD_FILE('/tmp/my_file.txt'));

您必须确保该文件可被MySQL读取，并且您的MySQL用户具有 LOAD DATA INFILE 所需的特权相同.

You'll have to make sure that the file is readable by MySQL, and that your MySQL user has the FILE privilege. This is the same privilege required for LOAD DATA INFILE.

这篇关于将文件内容插入MySQL表的列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！