select * into temp_test from user where id=007;

USE database;
-- 設(shè)置變量
SET @testCode='T001';
-- 創(chuàng)建臨時(shí)表
DROP TABLE IF EXISTS temp_test;
CREATE TABLE IF NOT EXISTS `temp_test`(
`name` VARCHAR(255),
`caption` VARCHAR(255),
`order` INT(11),
...
`entityId` BIGINT(20)
);
INSERT INTO temp_test
select item.name,item.caption,item.order,item.id from item item
inner join base base on base.id=item.baseid
where base.num='test01'
and base.id='T01'
select id into @itemid from temp_test;
update user set systemid=@itemid where `code`=@testCode;
...
INSERT INTO `base` (`userId`,`entityId`,`name`,`caption`, ...)
SELECT tpitem.entityId,tpitem.CONCAT('pre_',tpitem.name),tpitem.caption,tpitem.order,...
from
(
select * from temp_test test inner join temp_test2 test2 on test.entityid=test2.entityid
) tpitem
WHERE NOT EXISTS (SELECT 1 FROM item WHERE `code`=@testCode limit 1);
-- 刪除臨時(shí)表
DROP TABLE temp_test;

create table tmp (select ...)

drop table if EXISTS tmp_單個(gè)工位檢修結(jié)果表（檢查報(bào)告）上部;
?
create table tmp_單個(gè)工位檢修結(jié)果表（檢查報(bào)告）上部 (select workAreaName as '機(jī)器號(hào)',m.jobNumber as '檢修人員編號(hào)',u.userName as '檢修人員姓名',loginTime as '檢修開(kāi)始時(shí)間',
?
CONCAT(FLOOR((TIME_TO_SEC(exitTime) - TIME_TO_SEC(loginTime))/60),'分鐘') as '檢修持續(xù)時(shí)長(zhǎng)'
?
from maintenanceprocess as m LEFT JOIN user u ON m.jobNumber = u.jobNumber where m.jobNumber = [$檢修人員編號(hào)] and loginTime = [$檢修開(kāi)始時(shí)間]);#創(chuàng)建臨時(shí)表
?
select * from tmp_單個(gè)工位檢修結(jié)果表（檢查報(bào)告）上部;

BEGIN
?
#Routine body goes here...
?
declare cnt int default 0; ??
?
declare i int default 0; ??
?
set cnt = func_get_splitStringTotal(f_string,f_delimiter); ??
?
DROP TABLE IF EXISTS `tmp_split`; ??
?
create temporary table `tmp_split` (`val_` varchar(128) not null) DEFAULT CHARSET=utf8; ??
?
while i < cnt ??
?
do ??
?
set i = i + 1; ??
?
insert into tmp_split(`val_`) values (func_splitString(f_string,f_delimiter,i)); ??
?
end while;
?
END

drop table if exists a_temp;
create table a_temp as
select 表字段名稱(chēng) from 表名稱(chēng)

create temporary table 臨時(shí)表名稱(chēng)
select 表字段名稱(chēng) from 表名稱(chēng)