newbie q: update and/or insert?

13/04/2006, 15h40

Sorry for the newbie question here... but I haven't been able to figure
this out searching the web.

I'm using MySQL with PHP. I want to update a record if it already
exists. If it does not exist, I need to create a new record.

Is this done through a simple SQL command, or do I need to use PHP to
negotiate two separate UPDATE and INSERT statements?

13/04/2006, 16h03

You are looking for an object-relationnal mapping. This can do that (and
much more). But PHP is a beginner with objects. For now, this can be found
in Java, C++ languages only.

Pierre

"dx27s" <dx27s@yahoo.com> a écrit dans le message de news:
Bxs%f.10345$1q4.3243@bgtnsc05-news.ops.worldnet.att.net...
> Sorry for the newbie question here... but I haven't been able to figure
> this out searching the web.
>
> I'm using MySQL with PHP. I want to update a record if it already exists.
> If it does not exist, I need to create a new record.
>
> Is this done through a simple SQL command, or do I need to use PHP to
> negotiate two separate UPDATE and INSERT statements?

13/04/2006, 18h29

dx27s wrote:
> I'm using MySQL with PHP. I want to update a record if it already
> exists. If it does not exist, I need to create a new record.

This can be done either with the REPLACE statement, or the INSERT...ON
DUPLICATE KEY UPDATE. These two statements are subtly different.

REPLACE literally deletes an existing record and inserts a new one in
its place, using the values you specify. This means you need to provide
values for all the columns in your statement.

INSERT...ON DUPLICATE KEY UPDATE allows you to modify individual columns
in the case of an existing record, and leave the others alone. This was
added in MySQL 4.1.

Read the docs for more information:
http://dev.mysql.com/doc/refman/5.0/...duplicate.html
http://dev.mysql.com/doc/refman/5.0/en/replace.html

Regards,
Bill K.

13/04/2006, 21h28

"Pierre Gilquin" <pgilquin@bluewin.chAvirer> wrote in
news:443e5a26$1_2@news.bluewin.ch:

> You are looking for an object-relationnal mapping. This can do that
> (and much more). But PHP is a beginner with objects. For now, this can
> be found in Java, C++ languages only.

?????

13/04/2006, 15h40	#1
dx27s Messages: n/a Hébergeur:	newbie q: update and/or insert? Sorry for the newbie question here... but I haven't been able to figure this out searching the web. I'm using MySQL with PHP. I want to update a record if it already exists. If it does not exist, I need to create a new record. Is this done through a simple SQL command, or do I need to use PHP to negotiate two separate UPDATE and INSERT statements?

13/04/2006, 16h03	#2
Pierre Gilquin Messages: n/a Hébergeur:	Re: newbie q: update and/or insert? You are looking for an object-relationnal mapping. This can do that (and much more). But PHP is a beginner with objects. For now, this can be found in Java, C++ languages only. Pierre "dx27s" <dx27s@yahoo.com> a écrit dans le message de news: Bxs%f.10345$1q4.3243@bgtnsc05-news.ops.worldnet.att.net... > Sorry for the newbie question here... but I haven't been able to figure > this out searching the web. > > I'm using MySQL with PHP. I want to update a record if it already exists. > If it does not exist, I need to create a new record. > > Is this done through a simple SQL command, or do I need to use PHP to > negotiate two separate UPDATE and INSERT statements?

13/04/2006, 18h29	#3
Bill Karwin Messages: n/a Hébergeur:	Re: newbie q: update and/or insert? dx27s wrote: > I'm using MySQL with PHP. I want to update a record if it already > exists. If it does not exist, I need to create a new record. This can be done either with the REPLACE statement, or the INSERT...ON DUPLICATE KEY UPDATE. These two statements are subtly different. REPLACE literally deletes an existing record and inserts a new one in its place, using the values you specify. This means you need to provide values for all the columns in your statement. INSERT...ON DUPLICATE KEY UPDATE allows you to modify individual columns in the case of an existing record, and leave the others alone. This was added in MySQL 4.1. Read the docs for more information: http://dev.mysql.com/doc/refman/5.0/...duplicate.html http://dev.mysql.com/doc/refman/5.0/en/replace.html Regards, Bill K.

13/04/2006, 21h28	#4
Good Man Messages: n/a Hébergeur:	Re: newbie q: update and/or insert? "Pierre Gilquin" <pgilquin@bluewin.chAvirer> wrote in news:443e5a26$1_2@news.bluewin.ch: > You are looking for an object-relationnal mapping. This can do that > (and much more). But PHP is a beginner with objects. For now, this can > be found in Java, C++ languages only. ?????

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email