--- 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
At 12:23 PM 7/9/2004, you wrote:
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
app
--- 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 diff
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
