How to replace

[Reply Via Newsgroup]

Folks,

I'm writing a PHP based application and I'm pretty sure I can work out
the PHP code once I have direction with MySQL.

Basically - I have a record that has a primary key - There are times
when I want to change the reflected data - which I know I can do with
UPDATE - however - it is possible that the record does not exist in
which case I'd like it created.

Thus - is there a method that allows me to either replace a record, or
insert a new one if a specified one does not already exist?

All help, via the newsgroup, is much appreciated, thanks,

randell d.

[Pedro Graca]

Re: How to replace

Reply Via Newsgroup wrote:

I've seen a few quite strange names on and off the internet, but yours
wins the first prize!
[color=blue]
> Thus - is there a method that allows me to either replace a record, or
> insert a new one if a specified one does not already exist?[/color]

http://www.mysql.com/doc/en/REPLACE.html

--
USENET would be a better place if everybody read: : mail address :
http://www.catb.org/~esr/faqs/smart-questions.html : is valid for :
http://www.netmeister.org/news/learn2quote2.html : "text/plain" :
http://www.expita.com/nomime.html : to 10K bytes :