我无法将数据从主表复制到临时表

below is the code:

以下是代码：

CREATE TABLE maintable (
  Name varchar(10),
  phone_number numeric(10)
);
INSERT INTO maintable
  VALUES ("Max", 9896995632);
SELECT
  *
FROM maintable;
create table #TempTable as
maintable;
CREATE TABLE main