Jump to content

Archived

This topic is now archived and is closed to further replies.

jamshaid_0007

insert & update

Recommended Posts

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

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

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

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.