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 General Mailing

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

Re: INSERT INTO not working

2002-05-16 Thread Gerald Clark
Check your indexes. Daniel Lim wrote: Hi there, I have MySql version: 3.23.36 running on RedHat 7.1, it has been working fine for sometimes until a day ago when the INSERT into for new record appeared to return OK status but upon verifying the record isn't there? This is an example; To

INSERT INTO not working

2002-05-15 Thread Daniel Lim
Hi there, I have MySql version: 3.23.36 running on RedHat 7.1, it has been working fine for sometimes until a day ago when the INSERT into for new record appeared to return OK status but upon verifying the record isn't there? This is an example; To insert new record: mysql INSERT into

Re: INSERT INTO not working

2002-05-15 Thread Sven Bentlage
1. delete any whitespaces between the column name and the = and the values. 2. try using columnname=value That works for me. On Thursday, May 16, 2002, at 09:59 AM, Daniel Lim wrote: Hi there, I have MySql version: 3.23.36 running on RedHat 7.1, it has been working