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

Question

下面是代码:

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

Answer 1

Use Insert into in select statement.Now main table data move to temp table

CREATE TABLE maintable (Name varchar(10),phone_number numeric(10));
INSERT INTO maintable  VALUES ('Max', 9896995632);

SELECT * INTO #TempTable FROM maintable

SELECT * FROM #TempTable