Hi
After running this simple question I get this error. I have looked at the
my.cnf file and all looks fine and the system has 1.256 G of memory.
Can some one please tell me where I have gone wrong.

 select in_names.Username
 from in_names, in_names2
 where in_names.Username != in_names2.Username;
./mysql: Out of memory (Needed 8164 bytes)
ERROR 2008: MySQL client run out of memory

Simon
PS Both tables are indexed.

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to