Question

数据库出现错误，那位大侠帮忙看看如何解决！

Query Error: CREATE TEMPORARY TABLE heap_hitupdate (tid INT(10) UNSIGNED NOT NULL

,hits SMALLINT(6) UNSIGNED NOT NULL) TYPE = HEAP

The URL Is:

MySQL Server Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL

server version for the right syntax to use near 'TYPE = HEAP' at line 1 ( 1064 ) 查看

错误相关信息

Answer 1

兄dei，你这个是mysql版本的问题，mysql5.0之前这么写是可以的，mysql5.0以后必须写成
engin=HEAP，才能顺利通过。。

Answer 2

CREATE TEMPORARY TABLE heap_hitupdate (tid INT(10) UNSIGNED NOT NULL

,hits SMALLINT(6) UNSIGNED NOT NULL)engine= HEAP;
这样才对