Is it possible to update a record if it does not exist?

06-10-2007, 12:21 AM

I am trying to update a record if it exists or else create it if it does
not. Right now, I am implementing this in the logic of the programs that
manipulate the database, but I'd love to move that functionality into the
database instead - but I don't see how to do it. Am I missing something?

Many thanks,

Jeff Silverman

06-10-2007, 12:21 AM

Have you tried the REPLACE sql syntax. It updates a duplicate record and
adds it when not found.

REPLACE records SET my_name = 'Jeff' WHERE my_id = 12;

"Jeff Silverman" <jeffs@NOPAM.commercialventvacNOSPAM.com> wrote in message
news

an.2006.03.26.08.56.34.630453@NOPAM.commerci alventvacNOSPAM.com...
>I am trying to update a record if it exists or else create it if it does
> not. Right now, I am implementing this in the logic of the programs that
> manipulate the database, but I'd love to move that functionality into the
> database instead - but I don't see how to do it. Am I missing something?
>
> Many thanks,
>
>
> Jeff Silverman
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Updating record remotely from a script?	Burma Jones	Database	1	05-31-2007 8:48 PM
Does this software exist?	Amos Soma	Ebay Technical Questions	2	05-31-2007 10:03 AM
Good samaritans still exist	Ridwan Hughes	Ebay Technical Questions	2	05-30-2007 2:10 AM
Well crap. There goes my perfect record.	Lee	General Ebay Questions And Answers	49	05-30-2007 1:01 AM
PHP5 Static functions called through __call() that don't exist... yet	Jared Farrish	Pear	2	05-20-2007 6:34 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)