Phil,
If in the 2nd query you want teams with the highest count per cpid found
in the first query, I think you can map the 'Avoiding repeat
aggregation' pattern
(http://www.artfulsoftware.com/infotree/queries.php) to your problem
PB
-
Phil wrote:
Hi all,
got a simple problem I'm
Ofer Inbar wrote:
It appears to be an article for perl programmers not familiar with
MySQL, warning them of MySQL quirks they should be aware of. If you
write a perl script with DBD::MySQL and try one of the examples he
gave, and check your return status to see if the statement succeeded,
does
On Fri, Mar 28, 2008 at 3:46 PM, obed [EMAIL PROTECTED] wrote:
Hi all, i'm not trying to make trouble or bother someone with this
information, I'm a mysql user and I love it, I just wanna know your
point of view about it.
http://use.perl.org/~Smylers/journal/34246
When you're talking
It is probably keeping a global lock on something else: perhaps the
MyISAM key buffer is at fault. Try loading this table's indexes into
a different key buffer and see what happens.
On Fri, Mar 28, 2008 at 2:39 PM, Saravanan [EMAIL PROTECTED] wrote:
It doesn't lock single table it locks all
Nanni,
Thanks for the advices. How to make an installation? I use Fedora Core 8
where MySQL comes with the bundle. Do you think I should download the source
code and compile it and configure it using ./configure?
I did changed the cnf file to have 2 different configurations:
[EMAIL PROTECTED]