>>>>> "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/