--- Victor Pendleton <[EMAIL PROTECTED]> 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: [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] > ___________________________________________________________ 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]