Timo timo22345

avoidwork / gist:3749973

Created September 19, 2012 14:29

MySQL sp_split() splits a comma delimited string into a recordset & inserts it into target table or returns it

	-- ----------------------------
	-- Procedure structure for `sp_split`
	-- ----------------------------
	DROP PROCEDURE IF EXISTS `sp_split`;
	delimiter ;;
	CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_split`(IN toSplit text, IN target char(255))
	BEGIN
	# Temp table variables
	SET @tableName = 'tmpSplit';
	SET @fieldName = 'variable';