Re: How to count rows using DBI & mysql

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]


Come for the quick hacks, stay for the epiphanies.
	PerlMonks

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