Re: MySQL join problem

I doubt that a few thousand records would be more than mysql is capable of handeling. However my ignorance of Mysql is abundant. Does it use the /tmp directory and is your /tmp or root partition small? (guessing linux here). Does mysql use the /tmp directory for temporary tables? (Answer in ReadMe(s) probably)... ""Elliott Lee"" <elliott_lee@kitchenkeeper.com> wrote in message news:7f9b1549685643e126c2e3a4f988d09d@news.php.net... > Hi all, > > This may not necessarily be a PHP problem, but I was initially trying to do > this in PHP. I was trying to do a join of two tables and I get a response > from MySQL saying that some SQL temp file was out of space. One of my > tables has a few thousand items in it and my other table that I'm joining > with is pretty small, maybe 15 items. Is there a limitation to the size of > the query that I can do? I'm not out of disk space either. > > Elliott > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >