本文介绍了将文件内容插入MySQL表的列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我知道有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用户具有 FILE
特权.这与 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表的列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!