List:MySQL and Java« Previous MessageNext Message »
From:Christian Mack Date:July 20 1999 10:30am
Subject:Re: mysql ERROR 1114: The table 'SQL16a36b_0' is full
View as plain text  
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

Thread
mysql ERROR 1114: The table 'SQL16a36b_0' is fullAnh Bui18 Jul
  • Re: mysql ERROR 1114: The table 'SQL16a36b_0' is fullChristian Mack20 Jul