Just use SQL? INSERT INTO tbl, VALUES ('11','22','33') ON DUPLICATE KEY ....
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html On Wed, Oct 20, 2010 at 9:23 AM, Uri Guttman <u...@stemsystems.com> wrote: > >>>>> "SPS" == S Pratap Singh <kdari...@gmail.com> writes: > > > SPS> Insert query works fine but I am not able to figure out how to > SPS> achieve this "IF EXISTS then UPDATE else INSERT" using a one > SPS> liner MYSQL statement . If someone can give me an example to > SPS> write such query and execute it from perl then it would be really > SPS> appreciated. > > that is an sql question that has nothing to do with perl. please ask it > in an sql forum. the answer that i know is that you can't do it in basic > sql. > > uri > > -- > Uri Guttman ------ u...@stemsystems.com -------- http://www.sysarch.com-- > ----- Perl Code Review , Architecture, Development, Training, Support > ------ > --------- Gourmet Hot Cocoa Mix ---- http://bestfriendscocoa.com--------- > > -- > To unsubscribe, e-mail: beginners-unsubscr...@perl.org > For additional commands, e-mail: beginners-h...@perl.org > http://learn.perl.org/ > > > -- Regards, Chris Knipe