jamshaid_0007 0 Posted January 10, 2013 Share 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?????? Link to post Share on other sites
Christian F. 232 Posted January 10, 2013 Share 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. Link to post Share on other sites
jamshaid_0007 0 Posted January 10, 2013 Author Share 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 :-) Link to post Share on other sites
Christian F. 232 Posted January 10, 2013 Share Posted January 10, 2013 You're welcome. Link to post Share on other sites
Recommended Posts
Archived
This topic is now archived and is closed to further replies.