Fishbowl
Tables
(current)
Columns
Constraints
Orphan Tables
Routines
CreateList
Parameters
Name
Type
Mode
num
int
IN
tableName
varchar(50)
IN
Definition
BEGIN DECLARE cnt INT; SET cnt = 1; SET @SQL = CONCAT('DROP TEMPORARY TABLE IF EXISTS tmp_', tableName); PREPARE stmt FROM @SQL; EXECUTE stmt; DEALLOCATE PREPARE stmt; SET @SQL = CONCAT('CREATE TEMPORARY TABLE tmp_', tableName, ' (cnt int)'); PREPARE stmt FROM @SQL; EXECUTE stmt; DEALLOCATE PREPARE stmt; sloop:LOOP if (cnt <= num) THEN SET @SQL = CONCAT('insert into tmp_', tableName, ' value(', cnt, ')'); PREPARE stmt FROM @SQL; EXECUTE stmt; DEALLOCATE PREPARE stmt; SET cnt = cnt + 1; ELSE LEAVE sloop; END IF; END LOOP; END