mysql> CREATE TEMPORARY TABLE `tmp1`(id int primary key)engine=ndb;
ERROR 1478 (HY000): Table storage engine 'ndbcluster' does not support the create option 'TEMPORARY'
但是可以创建ALGORITHM的值为temptable属性的视图,当然视图在集群中是不能共享的。
mysql> create ALGORITHM=TEMPTABLE view pay_view1 as select * from pay;
Query OK, 0 rows affected (0.01 sec)