Hi Team,

I am not able to use multi value insert via argument in mysql stored procedure, Please help where am I wrong. Thanks in Advance !

mysql> insert into input_data1 values(7777),(6666),(5555),(9999);
Query OK, 4 rows affected (0.00 sec)

Problem
mysql> call mobile_series1('(99889988),(12334565)');
+-----------------------+
| mobile                |
+-----------------------+
| (99889988),(12334565) |
+-----------------------+
1 row in set (0.01 sec)

instead of 2 rows in table its only one row.

Function Code:
DELIMITER |
DROP PROCEDURE IF EXISTS mobile_series1;
CREATE PROCEDURE mobile_series1(IN str text)  
    LANGUAGE SQL     READS SQL DATA  
    BEGIN    
         DROP TABLE IF EXISTS input_data1 ;  
         CREATE TEMPORARY TABLE input_data1 (mobile varchar(1000)) engine=memory;
         INSERT INTO input_data1(mobile) VALUES (str);
	 SELECT * FROM input_data1;
 END |
DELIMITER ;




-- 
Best Regards 
Amit Jain
www.netcore.co.in
Ext - 4109
#9833777592



Banner plane



netCORE wins GOLD in 1st Smarties India 2012 Awards
Organized by Mobile Marketing Association (MMA)
Cross Media Integration for 'Colgate Active Salt Taste Challenge 2012' Campaign
Campaigns nominated for other categories
Brand Awareness
Active Wheel Mobile Marketing Campaign
Innovation
Active Wheel Mobile Marketing Campaign