i have some records in database... i want to update that records if the records does not exist then new record inserted how??????
insert & update
Started by jamshaid_0007, Jan 10 2013 12:25 PM
3 replies to this topic
#1
jamshaid_0007
-
- Members
-
- Newbie
- 6 posts
- LocationLahore punjab Pakistan
- Age:23
Posted 10 January 2013 - 12:25 PM
#2
Christian F.
-
- Staff Alumni
-
- Advanced Member
- 3,106 posts
- LocationNorway
Posted 10 January 2013 - 12:30 PM
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.
Keeping it simple.
#3
jamshaid_0007
-
- Members
-
- Newbie
- 6 posts
- LocationLahore punjab Pakistan
- Age:23
Posted 10 January 2013 - 12:38 PM
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 :-)
#4
Christian F.
-
- Staff Alumni
-
- Advanced Member
- 3,106 posts
- LocationNorway
Posted 10 January 2013 - 12:45 PM
You're welcome. 
Keeping it simple.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
