That's actually why I'm dropping/recreating, because I thought the
changes I have to make require multiple statements. Let me know if
that's a wrong assumption, here's what I have to do.
1. drop two foreign keys from Users to Actions (in the previous
example I gave).
2. expand INT to BIGINT on
Hi experts,
I am looking for a library for managing connection pool as I can't use
Tomcat, I found a couple of third party connection pool but with high
coupling - using those require me to change quite a lot existing code, I am
looking for something which can return a standard connection to
That worked perfectly, thanks!
On Fri, Feb 22, 2008 at 4:49 AM, C.R.Vegelin [EMAIL PROTECTED] wrote:
Hi Waynn,
Try:
SET @row := 0;
SELECT @row := @row + 1 AS Rank,
UserId, count(*) as NumActions from Actions group
by UserId order by NumActions desc limit 10;
HTH, Cor