--- Victor Pendleton <VPendleton@stripped> schrieb:
> What are the delimiters for this file?
I tried different variants:
No delimiters.
Delimiter ' (quote).
Delimiter " (doublequote).
All lines terminated by \n.
The files holds only a single column.
The column makes up 4200 rows.
Each row of different length (100 - 3000 chars).
It looks like:
ASEDVFGHGHFDSFDGFG\n
FHFGHFGTZUZUNZTWERTJUKJZUKZUKZTZHTR\n
JHKHKKFHGJJVJGJGJFDHFGJHFJHJH\n
System: Debian/Sarge, MySQL 4.0.18
>
> -----Original Message-----
> From: Jens Gerster
> To: mysql@stripped
> Sent: 7/9/04 12:23 PM
> Subject: Loading data into "TEXT" column;
>
> Hi,
>
> I'd like to load "TEXT"-data of variable length
> into an existing table with "CHAR"-columns.
>
> The input file consists of about 4200 lines
> with alphanumeric characters and newline only.
>
> Instead of filling up the "TEXT"-column
> next to the existing columns, Mysql
> appends new rows, filling up the "TEXT" column
> beginning behind the last row of the former table.
>
> I tried many options of "LOAD DATA INFILE" and
> checked my input file for problematic characters.
> Didn't help. I'm totally stuck and stopped
> working on the project.
>
> Could you tell me how to import my
> "TEXT" data correctly ?
>
> Thanks a lot for your help.
>
> Harald
>
>
>
>
>
>
>
>
___________________________________________________________
> Gesendet von Yahoo! Mail - Jetzt mit 100MB Speicher
> kostenlos - Hier
> anmelden: http://mail.yahoo.de
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/mysql?unsub=1
>
___________________________________________________________
Gesendet von Yahoo! Mail - Jetzt mit 100MB Speicher kostenlos - Hier anmelden:
http://mail.yahoo.de
