mysql - 具有外部约束的子表可以是临时表吗？

Question

当尝试这样做时，我收到以下错误:

1005 - Can't create table 'bidjunction.parent_table' (errno: 150)

我希望这是因为真正的表super_table不存在，只有临时表super_table。

可以这样做吗？它记录在哪里？

CREATE TEMPORARY TABLE IF NOT EXISTS super_table (
id INT NOT NULL,
data VARCHAR(45) NULL,
PRIMARY KEY (id))
ENGINE = InnoDB;

CREATE TEMPORARY TABLE IF NOT EXISTS parent_table (
id INT NOT NULL,
data VARCHAR(45) NULL,
PRIMARY KEY (id),
CONSTRAINT fk_parent_super
FOREIGN KEY (id)
REFERENCES super_table (id)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;

Answer 1

不，这不可能，here已记录在案

The FOREIGN KEY clause is specified in the child table. The parent and child tables must use the same storage engine. They must not be TEMPORARY tables