存储过程中不允许LOAD DATA [英] LOAD DATA is not allowed in stored procedures

问题描述

我有一个case每晚6pm自动导入数据到mysql。要导入的数据是data.txt。

I have a case to import data into mysql automatically every 6pm. data to be imported is "data.txt".

我在mysql中创建如下：

I created in mysql like this:

CREATE EVENT EVENT_NAME
ON SCHEDULE EVERY '18: 00:00 'DAY
DO
LOAD DATA LOCAL INFILE 'd :/ data.txt'
INTO TABLE table_name
FIELDS terminated BY ','
LINES terminated BY '\ n'
(atribut1, atribut2, atribut3);

如果我只是这样写

LOAD DATA LOCAL INFILE 'd :/ data.txt'
INTO TABLE table_name
FIELDS terminated BY ','
LINES terminated BY '\ n'
(atribut1, atribut2, atribut3);

查询已成功执行

如果我写代码像一个第一代码，而不是有一个错误LOAD DATA不允许在存储过程。是真的这样吗？如果它像我一样如何处理这种情况？感谢提前
对不起我的英语

but if i write the code like a fist code instead there is an error "LOAD DATA is not allowed in stored procedures". is it really like that? if it's like that how do i to handle such cases? thanks in advance sorry for my bad english

推荐答案

确实，你运气不好。

您可以通过调用以下方法从MySQL外部提交任意语句： mysql 这样的命令行客户端：

You can submit arbitrary statements from outside MySQL by calling the mysql command-line client like this:

    shell > mysql [options] -D [database] -e "LOAD DATA INFILE..."

这篇关于存储过程中不允许LOAD DATA的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！