Hello, I want to update my database if the key value is already there then it will update the required field else it will insert the new row in the same table.
Insert query works fine but I am not able to figure out how to achieve this "IF EXISTS then UPDATE else INSERT" using a one liner MYSQL statement . If someone can give me an example to write such query and execute it from perl then it would be really appreciated. Thank you. Pratap
