Re: Still having SELECT ... INTO OUTFILE problems - Leigh Sharpe - com.mysql.lists.win32

12 messages in com.mysql.lists.win32Re: Still having SELECT ... INTO OUTF...

From	Sent On	Attachments
Endre Szabo	02 Dec 2003 02:31
Groberts1	02 Dec 2003 04:21
Ignatius Reilly	02 Dec 2003 04:40
Moon...@aol.com	02 Dec 2003 07:53
Groberts1	02 Dec 2003 08:44
Moon...@aol.com	02 Dec 2003 10:53
Groberts1	02 Dec 2003 13:17
Moon...@aol.com	02 Dec 2003 13:56
Groberts1	02 Dec 2003 14:07
Groberts1	04 Dec 2003 05:13
Leigh Sharpe	04 Dec 2003 13:50
John Bonnett,R&D Aust	04 Dec 2003 14:45

Subject:	Re: Still having SELECT ... INTO OUTFILE problems
From:	Leigh Sharpe (lsha...@pacificwireless.com.au)
Date:	12/04/2003 01:50:32 PM
List:	com.mysql.lists.win32

This may be your problem:

from harrisjmts j, harrisrels r, harrisbrs b

This will give you a very large table, because you are (implicitly) joining these three tables. The resulting table will be the size of table1*table2*table3.

OK, this is getting ridiculous...

I issued this command:

select j.recid, j.filenum, j.grantor, j.grantee, j.description, j.filmcode, j.filedate, j.type into outfile 'F:/Judgment Collection/Harris Jmt-Rels/Dates SQL-Formatted/openjmts.txt' from harrisjmts j, harrisrels r, harrisbrs b where not (j.Grantee = r.Grantee and j.Filedate <= r.Filedate and j.Description = r.Description) and not (j.Grantee = b.Grantee) and not (j.Grantee = b.Grantor) limit 0,-1;

and I got Errcode 28, out of disk space. Windows Explorer tells me the outfile is 60 GB but also says I have 60 GB free on an 80 GB hard drive. Word's Open dialog tells me it's 4 GB which I think is the limit on W2K Pro. Even if it's "only" 4 GB, this is larger than the entire table harrisjmts! Why would the outfile contain more data than the table I'm querying against?