一次将数据插入到表中，然后从mySQL select命令中检索数据

我已经提到了我的原始交易表和临时交易表，我想将数据插入到临时交易表中，我选择交易表的值

I have mentioned my Original transaction table and temporary Transaction Table I want to insert data to temporarytransaction table which I select values of Transaction table

    CREATE TABLE Transaction(
    Tid int auto_increment primary key,
    T_type varchar(20),
    Amount decimal(10,2),
    Tdate DATETIME,
    accountNo int,
    CONSTRAINT FOREIGN KEY(AccountNo) REFERENCES Account(AccountNo)
    ); 



CREATE TABLE tempTransaction(
    Tid int auto_increment primary key,
    T_type varchar(20),
    Amount decimal(10,2),
    Tdate DATETIME,
    accountNo int,
    CONSTRAINT FOREIGN KEY(AccountNo) REFERENCES Account(AccountNo)
    );

我想将此查询修改为可以使用的查询，这是我的问题

I want edit this query to working one That is my Question

INSERT INTO temporarytransaction VALUES (SELECT * FROM Transaction WHERE `Tdate` BETWEEN "2012-03-15" AND "2016-03-31");