Re: Loading data into "TEXT" column;

2004-07-09 Thread Jens Gerster
--- mos <[EMAIL PROTECTED]> schrieb: > At 12:23 PM Thanks a lot, Mike. It works. I spent many hours with this problem. I also tried the trick with a temporary table, but used the "INSERT" command, which didn't help. All the best to you,Harald > > Harald, > 1) load the data into

RE: Loading data into "TEXT" column;

2004-07-09 Thread Jens Gerster
0 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] &g

Loading data into "TEXT" column;

2004-07-09 Thread Jens Gerster
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