I have tried either give me all members in all
groups, or only records where Jim is a member. My closest query follows,
then a sketch of my tables with a results set at the end. Can someone
please tell me where I an blowing it?
Thanks -
Dan Hansen
SELECT groups.name AS group_name
it?
Dan Hansen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I ended up stopping and restarting MySQL -- which cleared up the
problem. Index creation took around a minute.
Dan
At 05:38 PM 10/15/03, Matt W wrote:
Hi Dan,
133MHz huh? :-) Well, how large is the table? Huge rows? How many other
indexes are on the table and on how many columns? Are those