You can look up error codes with perror.
: perror 28 Error code 28: No space left on device
You've run out of disk space.
Michael
sam wun wrote:
Hi,
I was trying to optimize a sql (for INNER JOIN) by spliting the sql into 2 temporary tables.
But I got error with the following sql:
mysql> CREATE TEMPORARY TABLE pastsales_tab_3141604663377652915968 SELECT c.salescode,c.type, c.custcode, i.basename, i.vendorname, t.salesvolume, t.netsales, t.prodcode, i.prodname from inventory i INNER JOIN transaction t ON i.prodcode = t.prodcode AND date(t.date) >= '2003-01-23' AND date(t.date) <= '2004-01-23' INNER JOIN customer c ON c.custcode = t.custcode ;
ERROR 1030 (HY000): Got error 28 from storage engine
How can I correct this error? I musing mysql5.01
Thanks Sam.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
