Mathias, Thanks for the reply. I couldn't find a server variable named "max_temp_table_size" but I did find one named "max_heap_table_size". Is that what you meant? BTW, I forgot to mention that I'm using MySQL 4.0.20. Could it be that this variable that you mention is only in later versions?
Basically, what I'm trying to do is a multi-table update statement. If I select too many rows I get the "Table #sql-123 is full" error. If I bite off a small enough chunk, the query works. Thanks again, Tripp --- [EMAIL PROTECTED] wrote: > hi, > seems to be a temp table (sybase notation). > see max_temp_table_size > > Mathias > Selon Emmett Bishop <[EMAIL PROTECTED]>: > > > Howdy all, I have a question about a SQL statement > > that I'm trying to execute. When I execute the > > statement I get the following error: The table > > '#sql_bd6_3' is full. > > > > What does this mean exactly? > > > > Thanks, > > > > Tripp > > > > > > > > __________________________________ > > Yahoo! Mail Mobile > > Take Yahoo! Mail with you! Check email on your > mobile phone. > > http://mobile.yahoo.com/learn/mail > > > > -- > > 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] > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]