使用临时表“无法重新打开表：'临时\u name'时发生mysql错误”

Question

我使用python调用一个创建临时表的存储过程

然后我试图从那个表中选择，但是得到了错误

Caught an exception while rendering: (1137, "Can't reopen table: 'temporary_name'")

谁能看出我错在哪里吗

我的代码是

^{pr2}$

这个表不是临时的，我只是把它放进去

Answer 1

从MySQL documentation（参见粗体文本）：

You cannot refer to a TEMPORARY table more than once in the same query. For example, the following does not work:

mysql> SELECT * FROM temp_table, temp_table AS t2;
ERROR 1137: Can't reopen table: 'temp_table'

This error also occurs if you refer to a temporary table multiple times in a stored function under different aliases, even if the references occur in different statements within the function.