Analysis of mysql temporary table usage [query results can be stored in temporary tables]

select * into tmp from maintenanceprocess

create table tmp (select ...)

#Single station maintenance result table upper part drop table if EXISTS tmp_Single station maintenance result table (inspection report) upper part;
create table tmp_ single workstation maintenance result table (inspection report) upper part (select workAreaName as 'machine number', m.jobNumber as 'maintenance personnel number', u.userName as 'maintenance personnel name', loginTime as 'maintenance start time',
CONCAT(FLOOR((TIME_TO_SEC(exitTime) - TIME_TO_SEC(loginTime))/60),'minutes') as 'Maintenance duration'
from maintenanceprocess as m LEFT JOIN user u ON m.jobNumber = u.jobNumber where m.jobNumber = [$maintenance personnel number] and loginTime = [$maintenance start time]
);#Create a temporary table select * from tmp_single station maintenance result table (inspection report) upper part;

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