mysql> insert into table1 select distinct field1 , MIN(field2) from table2 where field2 >="2001-12-01 00:00:00" group by field2 ; ERROR 1114: The table 'SQLb73d_0' is full mysql>
please help to fix this error Name : Mohamed Abd El-Samei Mohamed Title : System Administrator Comp. : Soficom Communications S.A.E Tele. : 737-1952/3 Fax : 7547415 E-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- 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