Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re^3: MySQL syntax error for ON DUPLICATE KEY UPDATE

by rhesa (Vicar)
on Jul 20, 2008 at 08:12 UTC ( #698889=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    insert into  foo    (bar, baz) 
                 values (?,   ?)
    on duplicate key update
                 bar = values(bar)
               , baz = values(baz)
    
  2. or download this
    my $stmt = 'INSERT INTO contact_form (' . join(',', keys %sql) . ') 
                VALUES (' . join(',', ('?') x keys %sql) . ') 
                ON DUPLICATE KEY UPDATE '. join(', ', map { "$_ = values($
    +_)" } keys %sql);
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://698889]
help
Chatterbox?
[Discipulus]: i fear no
[Discipulus]: i invented also 'gired'
[Lady_Aleena]: Discipulus, then that is a problem. I wanted to find total seconds of my entire .mp3 collection to do some math on it to see how many days of continuous music i have.
[LanX]: darn. .. I wanted to see Marine and Melonchon go to next round, just for fun xD
[Discipulus]: LA use Perl: traversing a dir tree is simple; foreach file mp3 $sec+= use Mp3::Info
[Lady_Aleena]: Discipulus, I was able to get the sum of the seconds on the command line using awk. Then I ran the result through a perl script and got the result. It came bach with 4 days, 9 hours, 56 minutes, 43 seconds.
[Lady_Aleena]: s/bach/back/;
[Discipulus]: gired anyway is the intermediate state between hired and fired (and vice versa;)
[Lady_Aleena]: Discipuluis, I don't know if I want to fight with File::Find. File::Find and I are not friends.
[Discipulus]: 4 day Bach is too muche even for me

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (9)
As of 2017-04-23 20:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (432 votes). Check out past polls.