in reply to How to count rows using DBI & mysql - Performance results

Just a short tip:
The REPLACE function from MYSQL. It checks if the row is existing, and doing an INSERT (if not), or an UPDATE (if it is). However if you do not want the UPDATE feature, it does not help you.

--
tune

  • Comment on Re: How to count rows using DBI & mysql - Performance results

Replies are listed 'Best First'.
Re: Re: How to count rows using DBI & mysql - Performance results
by Brovnik (Hermit) on Jun 11, 2001 at 18:51 UTC
    I tried that, but REPLACE only works on a unique index. I need to be able to have e.g. 
    COL1        COL2

A           B
A           C
A           D
B           C
C           D
B           D

    [download]
    So neither column is unique.
    --
    Brovnik
[reply]
[d/l]

In Section Meditations