Re: Error with Storage engine

2005-01-23 Thread Michael Stassen
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> CR

Error with Storage engine

2005-01-22 Thread sam wun
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,