jamshaid_0007 0 Posted January 10, 2013 i have some records in database... i want to update that records if the records does not exist then new record inserted how?????? Share this post Link to post Share on other sites
Christian F. 232 Posted January 10, 2013 INSERT ... ON DUPLICATE UPDATE ... That's the syntax you're looking for. In other words, opposite of what you described it as, but with the same end result. A Google search for it should provide you with lots and lots of examples, and tutorials, on how to use it. Share this post Link to post Share on other sites
jamshaid_0007 0 Posted January 10, 2013 INSERT ... ON DUPLICATE UPDATE ... That's the syntax you're looking for. In other words, opposite of what you described it as, but with the same end result. A Google search for it should provide you with lots and lots of examples, and tutorials, on how to use it. thanku :-) Share this post Link to post Share on other sites
Christian F. 232 Posted January 10, 2013 You're welcome. Share this post Link to post Share on other sites
