Re: MySQL error 1114: The table 'SQL7db1e_0' is full

2001-04-06 Thread Gerald Clark
; > tb_b: > id (int) > type_id (int) > value (varchar) > > record on tb_a is 1 and record on tb_b is 1000 > > When I exec that query: > SELECT a.*, b.value AS name > FROM tb_a AS a LEFT JOIN tb_b AS b > ON a.name_sid = b.id AND b.type_id = 1 > ORDER B

MySQL error 1114: The table 'SQL7db1e_0' is full

2001-04-06 Thread Petio Tonev
AS name FROM tb_a AS a LEFT JOIN tb_b AS b ON a.name_sid = b.id AND b.type_id = 1 ORDER BY name ,I receive "MySQL error 1114: The table 'SQL7db1e_0' is full". How I can fix that. Best regards -- Petio To