On Wed, Jul 15, 2009 at 9:21 AM, Govinda<govinda.webdnat...@gmail.com> wrote:
> Reading docs..  I want to be sure of things...  have your verification of my
> understanding(s)-
>
> Does setting a mysql db column (say "myPrimarykeyID") with the 'primary_key'
> & 'auto_increment' flags totally negate the logic for ever having to use ON
> DUPLICATE KEY UPDATE in an INSERT?
>
> Or is it that I can do an INSERT with SET
> myPrimarykeyID=someAlreadyExistingVal, a=1, b=2....  ON DUPLICATE KEY UPDATE
>  a=edited1, b=edited2 ...
>
> I am trying to learn/work out the mysql/php code that will allow me to
> either create *or* edit a record, in one fell swoop.
>
> Thanks for any insight!
> -Govinda
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


If that is the goal use the REPLACE INTO sql syntax

You really don't want to allow duplicates in primary keys, that
completely negates the usefulness of that key



-- 

Bastien

Cat, the other other white meat

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to