Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

Re: Re: mysql insert/update

by rsiedl (Friar)
on May 31, 2004 at 10:57 UTC ( #357765=note: print w/replies, xml ) Need Help??

in reply to Re: mysql insert/update
in thread mysql insert/update

Thanks Liz,
Not 100% what I was after but has put me onto "ON DUPLICATE KEY UPDATE".
Now I just need to decide if I should update my MySQL :)

Update: My reasons for not using REPLACE is from my understanding it will delete the row and re-insert it with any column that I dont specify a value for, becoming the default value. I am after something where I am able to just update one column value keeping the others in there also.

Replies are listed 'Best First'.
Re^3: mysql insert/update
by Anonymous Monk on Dec 07, 2008 at 13:58 UTC

    Log In?

    What's my password?
    Create A New User
    Node Status?
    node history
    Node Type: note [id://357765]
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others avoiding work at the Monastery: (4)
    As of 2016-10-25 05:03 GMT
    Find Nodes?
      Voting Booth?
      How many different varieties (color, size, etc) of socks do you have in your sock drawer?

      Results (315 votes). Check out past polls.