List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:April 6 2001 1:43pm
Subject:Re: MySQL error 1114: The table 'SQL7db1e_0' is full
View as plain text  
It is in the Problems and Common Errors section of the manual.


Petio Tonev wrote:
> 
> Hi,
> 
> I have problem with left join on two table.
> Version on MySQL is 3.22.25 and it started under linux.
> 
> The table is:
> 
> tb_a:
> id (int)
> name_sid (int)
> 
> tb_b:
> id (int)
> type_id (int)
> value (varchar)
> 
> record on tb_a is 10000 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 BY name
> 
> ,I receive "MySQL error 1114: The table 'SQL7db1e_0' is full".
> 
> How I can fix that.
> 
> Best regards
> --
> Petio Tonev
> ptonev@stripped
> 
> ---------------------------------------------------------------------
> 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 <mysql-thread70730@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thread
MySQL error 1114: The table 'SQL7db1e_0' is fullPetio Tonev6 Apr
  • Re: MySQL error 1114: The table 'SQL7db1e_0' is fullGerald Clark6 Apr