MySQL 临时表

/*
**将数据批量插入到临时表tempUser
*/
CREATE TEMPORARY TABLE tempUser
SELECT FID,FAccount,FCompanyID
FROM tusers
WHERE FCompanyID=36052;

SELECT * FROM tempUser;

DROP TABLE tempUser;

 

/*
**创建临时表tempUser
*/
DROP TEMPORARY TABLE IF EXISTS tempUser;
CREATE TEMPORARY TABLE tempUser
(
    FIndex INT PRIMARY KEY AUTO_INCREMENT,
    FID INT,
    FName VARCHAR(40),
    FCompanyID INT
)ENGINE = MEMORY;

-- 插入数据到临时表
INSERT INTO tempUser(FID,FName,FCompanyID)
SELECT FID,FAccount,FCompanyID
FROM tusers
WHERE FCompanyID=36052;
SELECT * FROM tempUser;


-- 清理临时表
DROP TABLE tempUser