Hello Everyone!
Is there any one that can help me solve this problem, I am trying to
up load 6 large file to the database, I am having issue with the LOAD
DATA LOCAL INFILE function of MySQL???
It does not matter if I do:
LOAD DATA LOCAL INFILE 'www/dev/uploads/EO2.LST'
INTO TABLE irs_rawdata
which gives me the errors:
Query OK, 570845 rows affected, 65535 warnings (20.71 sec)
Records: 570845 Deleted: 0 Skipped: 0 Warnings: 18267040
the effect of that in the table is that it loads the first field of
each line only
--------------------------
if I do:
LOAD DATA LOCAL INFILE 'www/uploads/EO2.LST'
INTO TABLE irs_rawdata
(@var1)
SET
EIN = substr( @var1 , 0, 9 ) ,
PNO = substr( @var1 , 9, 70 ) ,
ICN = substr( @var1 , 79, 35 ) ,
Street_Address = substr( @var1 , 114, 35 ) ,
City = substr( @var1 , 149, 22 ) ,
State = substr( @var1 , 171, 2 ) ,
Postal_Code = substr( @var1 , 173, 10 ) ,
GEN = substr( @var1 , 183, 4 ) ,
Subsection_Code = substr( @var1 , 187, 2 ) ,
Affiliation_Code = substr( @var1 , 189, 1 ) ,
Classification_Code = substr( @var1 , 190, 4 ) ,
Ruling_Date = substr( @var1 , 194, 6 ) ,
Deductibility_Code = substr( @var1 , 200, 1 ) ,
Foundation_Code = substr( @var1 , 201, 2 ) ,
Activity_Code = substr( @var1 , 203, 9 ) ,
Organization_Code = substr( @var1 , 212, 1 ) ,
UL_Code = substr( @var1 , 213, 2 ) ,
AFED = substr( @var1 , 215, 6 ) ,
Tax_Period = substr( @var1 , 221, 6 ) ,
Asset_Code = substr( @var1 , 227, 1 ) ,
Income_Code = substr( @var1 , 228, 1 ) ,
FR_Code = substr( @var1 , 229, 3 ) ,
Blanks = substr( @var1 , 232, 3 ) ,
Accounting_Period = substr( @var1 , 235, 2 ) ,
Asset_Amount = substr( @var1 , 237, 13 ) ,
Income_Amount = substr( @var1 , 250, 13 ) ,
IAN_NS = substr( @var1 , 263, 1 ) ,
F_990_RA = substr( @var1 , 264, 13 ) ,
RAN_NS = substr( @var1 , 277, 1 ) ,
NTEE_Code = substr( @var1 , 278, 4 ) ,
SN_SNL = substr( @var1 , 282, 35 ) ,
Line_Feed = substr( @var1 , 317, 1 );
which gives me the errors:
Query OK, 1 row affected, 65535 warnings (1 min 15.87 sec)
Records: 570845 Deleted: 0 Skipped: 570844 Warnings: 262040
the efffect is:
it only puts in one row and with that row it does not enter any thing
for the first field then it takes the last char of the first field
puts it in the next field and pushs all other fields one to the right
PLEASE any help would be great this is holding up the ablility to
filter out and start work on the data thats in the files
Sincerely,
Christopher
