Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: mysql insert/update

by liz (Monsignor)
on May 31, 2004 at 10:05 UTC ( #357762=note: print w/ replies, xml ) Need Help??


in reply to mysql insert/update

See REPLACE.

Liz


Comment on Re: mysql insert/update
Re: Re: mysql insert/update
by rsiedl (Friar) on May 31, 2004 at 10:57 UTC
    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 :)
    Cheers,
    Reagen

    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.

    Log In?
    Username:
    Password:

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

    How do I use this? | Other CB clients
    Other Users?
    Others examining the Monastery: (9)
    As of 2014-10-01 09:31 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      How do you remember the number of days in each month?











      Results (392 votes), past polls