labtech
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_split
Parameters
Name
Type
Mode
toSplit
text
IN
outputTable
varchar(50)
IN
Definition
BEGIN # Dropping table SET @sql := CONCAT('DROP TABLE IF EXISTS ', outputTable); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; # Creating table SET @sql := CONCAT('CREATE TEMPORARY TABLE ', outputTable, ' (`variable` VARCHAR(1000))'); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; # Preparing toSplit SET @vars := toSplit; SET @vars := CONCAT("('", REPLACE(@vars, ",", "'),('"), "')"); # Inserting values SET @sql := CONCAT('INSERT INTO ', outputTable, ' VALUES ', @vars); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; END