What are the delimiters for this file?
-----Original Message-----
From: Jens Gerster
To: [EMAIL PROTECTED]
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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
