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
