Re: MUltiple value in single insert is not working in mysql procedure

2012-12-05 Thread hsv
2012/12/03 19:10 +0530, amit Problem mysql> call mobile_series1('(99889988),(12334565)'); You are expecting MySQL to turn one string operand into twain number operands. That does not happen, unless you use PREPARE, which, I suspect, is not part of your homework. -- MySQL Ge

Re: MUltiple value in single insert is not working in mysql procedure

2012-12-03 Thread Peter Brawley
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(),(),(),(); Query OK, 4 rows affected (0.00 sec) *Problem* mysql