On 2012-12-03 7:40 AM, amit wrote:
> 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 TEMPORARYTABLE input_data1(mobile varchar(1000)) engine=memory;
> INSERT INTO input_data1(mobile) VALUES (str);
> SELECT * FROM input_data1;
> END |
> DELIMITER;|
|Dynamic SQL requires PREPARE, see the manual page for that cmd.
PB
|
> |
>
>
>
> |
>
> --
> Best Regards
> Amit Jain
> www.netcore.co.in
> Ext - 4109
> #9833777592
>
>
> Banner plane
>
>
>
> netCORE wins GOLD in 1^st 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
>
>
>
