mysql中临时表的旧代码TYPE = HEAP错误 [英] Error with old code TYPE=HEAP for temporary table in mysql

问题描述

我有一个正在工作的旧代码:

I have an old code that was working:

CREATE TEMPORARY TABLE temp_tree (id INTEGER, parent_id INTEGER) type=HEAP;

现在我有mysql 5，此代码无法正常工作. 在内存中创建临时表的正确方法是什么? 我已经搜索了文档

Now I have mysql 5 and this code is not working. What is the proper way to create temporary table in the memory? I have searched into documentation

但找不到合适的例子.

推荐答案

在新版本中不推荐使用类型.检查mysql的版本并使用Engine = Memory.

Type is deprecated in new versions. Check the version of mysql and use Engine = Memory.

这篇关于mysql中临时表的旧代码TYPE = HEAP错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！