Hello Stefan, Wednesday, April 02, 2003, 2:27:40 PM, you wrote:
Here is table status: +-------+--------+------------+---------+----------------+-------------+-----------------+--------------+-----------+---------------------+---------------------+---------------------+---------------------+----------------+---------+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +-------+--------+------------+---------+----------------+-------------+-----------------+--------------+-----------+---------------------+---------------------+---------------------+---------------------+----------------+---------+ | linii | MyISAM | Dynamic | 1194745 | 130 | 155429332 | 4294967295 | 42998784 | 0 | 3472328119327703312 | 2003-04-02 10:48:27 | 2003-04-02 12:17:14 | 2003-04-02 10:50:26 | | | +-------+--------+------------+---------+----------------+-------------+-----------------+--------------+-----------+---------------------+---------------------+---------------------+---------------------+----------------+---------+ 1 row in set (0.00 sec) SH> Hello, >> When I execute this SQL: >> update table1 as a, table2 as b set a.field1=b.field1 >> where a.field2=b.field2 and a.field3=b.field3 and a.field4=b.field4 >> I received this error "execute failed: The table 'a' is full " >> What is the meaning of this? SH> This means that the table is full ;-) SH> You can find possible reasons for that here: SH> http://www.mysql.com/doc/en/Full_table.html SH> If you can't find a reason yourself, you might send the output of the SH> following statement to the list: mysql>> SHOW TABLE STATUS LIKE 'table1'; SH> This might help us find the reason for your problem. -- Best regards, PandaCoop-Krasimir_Slaveykov mailto:[EMAIL PROTECTED] Tel: ++359 2 942 75 94 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
