MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jens Gerster Date:July 9 2004 5:23pm
Subject:Loading data into "TEXT" column;
View as plain text  

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.



Gesendet von Yahoo! Mail - Jetzt mit 100MB Speicher kostenlos - Hier anmelden:
Loading data into "TEXT" column;Jens Gerster9 Jul
  • Re: Loading data into "TEXT" column;mos9 Jul
    • Re: Loading data into "TEXT" column;Jens Gerster10 Jul
RE: Loading data into "TEXT" column;Victor Pendleton9 Jul
  • RE: Loading data into "TEXT" column;Jens Gerster9 Jul