Re: Multiple inserts/updates through DBD::mysql

[Randy Clamons]

I'm a bit confused as to what you are actually trying to do. Your three statements--

update kalle set lars = 1; 
update kalle set leif = 2; 
update kalle set harry = 3;

Would update all rows of your table (kalle), setting the values of lars, leif, and harry to 1,2,3 respectively. If your table has only one row with the three columns, write as a single update statement:

UPDATE calle SET
     lars = 1,
     leif = 2,
     harry = 3

Since your sample code did not include a WHERE clause, that's about the best I can do.