Hi, Georg Richter, Thanks after got your mail that
>perror 28 >Error code 28: No space left on device I try to check my disk spack it have 2 GB space left so it may not cause by this problem .And I found that with MySQL 4.0.1 it error but not error in 3.23.49a thank again. Kittiphum Worachat,M.T. www.hatyailab.com >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
