List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:December 3 2012 5:58pm
Subject:Re: MUltiple value in single insert is not working in mysql procedure
View as plain text  
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
>
>
>


Thread
MUltiple value in single insert is not working in mysql procedureamit3 Dec
  • Re: MUltiple value in single insert is not working in mysql procedurePeter Brawley3 Dec
  • Re: MUltiple value in single insert is not working in mysqlprocedurehsv3 Dec