MySQL-使用可变路径加载数据文件 [英] MySQL - Load Data Infile with variable path

问题描述

我在设置用于将数据放入表中的变量路径时遇到问题. 这就是我构建路径的方式:

I'm having a problem with setting a variable path for putting data into my table. This is how i build my path:

SET @path1 = CONCAT('C:/Projekte/Metrics/DXL_CSV_EXPORT_DATA/', YEAR(NOW()), '_',    MONTH(NOW()), '_', DAY(NOW()), '%', '/_','BeMiko/');`

每天在服务器上创建另一个文件夹.我想每天自动从这些文件夹内的.csv文件中导入信息.

Every day another Folder is created on the server. I want to automatically import the information from the .csv files from inside these folders each day.

我从具有以下内容的文件中导入数据:

I import data from files with:

LOAD DATA INFILE 
path...
IGNORE INTO TABLE table1 FIELDS TERMINATED BY ';' ENCLOSED BY '"'
LINES TERMINATED BY '<*line_end*>\r\n' IGNORE 1 ROWS;

如何使用@ path1变量中的字符串作为路径? 或者，如果无法做到这一点:还有其他方法可以解决此问题吗?

How do i use the string inside my @path1 variable as path? Or if this is not possible: Are there other ways to solve this problem?

推荐答案

变量不能用于替换LOAD DATA INFILE语句中的路径.

Variables can't be used to substitute paths in the LOAD DATA INFILE statement.

也:

在允许使用表达式的大多数情况下，都可以使用用户变量.当前，这不包括明确需要文字值的上下文，例如SELECT语句的LIMIT子句或LOAD DATA语句的IGNORE N LINES子句.

User variables may be used in most contexts where expressions are permitted. This does not currently include contexts that explicitly require a literal value, such as in the LIMIT clause of a SELECT statement, or the IGNORE N LINES clause of a LOAD DATA statement.

• 如 mysql手册中所示
• as seen in the mysql manual

这篇关于MySQL-使用可变路径加载数据文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！