Anh Bui wrote:
>
> Hi,
> Anyone knows what this error mean: ERROR 1114: The table 'SQL16a36b_0' is full?
> I got it when I used the following query (either inside my Java program or directly
> inside the MySQL environment on UNIX:
> SELECT distinct
> MainLPPartners.SSN,SubLPPartners.Partner,SubLPPartners.Exercise from
> MainLPPartners,SubLPPartners where
> MainLPPartners.SSN!=SubLPPartners.Partner and
> MainLPPartners.Exercise=SubLPPartners.Exercise and
> MainLPPartners.GroupId=SubLPPartners.GroupId order by MainLPPartners.SSN
>
> Here is a little more info on the tables I am accessing: each table has 1920 rows of
> records and their data dictionaries are:
> mysql> describe MainLPPartners;
> +----------+---------------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +----------+---------------------+------+-----+---------+-------+
> | SSN | varchar(255) | YES | | NULL | |
> | Exercise | tinyint(2) unsigned | YES | | NULL | |
> | GroupId | tinyint(5) unsigned | YES | | NULL | |
> +----------+---------------------+------+-----+---------+-------+
> mysql> describe SubLPPartners;
> +----------+---------------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +----------+---------------------+------+-----+---------+-------+
> | Partner | varchar(255) | YES | | NULL | |
> | Exercise | tinyint(2) unsigned | YES | | NULL | |
> | GroupId | tinyint(5) unsigned | YES | | NULL | |
> +----------+---------------------+------+-----+---------+-------+
>
> Thanks.
>
> Anh
Hi Anh
Please read chapter "17.2.6 The table is full error" in the manual.
Tschau
Christian
