On Monday, 13. May 2002 07:20, Kittiphum Worachat wrote: Hi, > > In select field list if they have some field that field type is text or > blob and if I use group by some filed MySQL will generate "Got error 28 > from table handler" the query like this > > select a.f1,a.f2,a.f3,b.f1,b.f2 > from table_a as a,table_b as b > where a.f1=b.f1 > and a.f1='xxx' > group by b.f2 > > if f2.b if mediumtext I will got error 28 but when change type to varchar > it OK but I realy need mediumtext type how to solve this problem >
For a error description use perror perror 28 Error code 28: No space left on device So maybe you should delete some stuff on your disks or buy a new one. Regards Georg --------------------------------------------------------------------- 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
