如果从指定表插入数据到当前表，例如在数据库中创建了一个表customer_t1的备份表customer_t2，现在需要将表customer_t1中的数据插入到表customer_t2中，则可以执行如下命令。

CREATE TABLE customer_t2 (XXX);

INSERT INTO customer_t2 SELECT * FROM customer_t1;

或等价于

CREATE TABLE customer_t2 AS SELECT * FROM customer_t1;