* Frank Bax <[EMAIL PROTECTED]> [040615 12:59]:
> At 03:14 PM 6/15/04, Tim Johnson wrote:
> >We are importing data from 3 CSV files.
<..> >the 3 tables into 1.
> >
> >Taken as a sum, we should have about 330 columns
> >and 5000+ rows.
Hi Frank:
>
> Are you saying:
> each CSV contains about 110
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [040615 12:11]:
>
> Well, Tim, since you can't fix the data on the way out of the database (the
> original application), you will have to fix it on the way in. My best
> advice is to create 3 new tables in MySQL that look just like your 3 raw
> data files.
At 03:14 PM 6/15/04, Tim Johnson wrote:
We are importing data from 3 CSV files.
Documentation regarding the originating
database is for the most part, not available
to us.
Translating directly from CSV to .sql files, we
can see that the three files are really the
first, second and third parts of on
Well, Tim, since you can't fix the data on the way out of the database (the
original application), you will have to fix it on the way in. My best
advice is to create 3 new tables in MySQL that look just like your 3 raw
data files. Use a LOAD DATA INFILE command to populate each of your 3
"raw" t
