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