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?
This means that the table is full ;-) You can find possible reasons for that here: http://www.mysql.com/doc/en/Full_table.html If you can't find a reason yourself, you might send the output of the following statement to the list: mysql> SHOW TABLE STATUS LIKE 'table1'; This might help us find the reason for your problem. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
