John, thanks for your help, I've solved my problem splitting the field into
three fields on a temporary table. Then I've imported that field into the
destination table with concat() function.
Stefano
-- Messaggio originale --
From: John Doe [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To:
Rhino, I've answered only to you and not to the list too, because I've already
posted the same words answering to another mailing list user :-)
My first problem is that the txt files I need to import have a fix structure
without separators. After the field of 595 characters, there is another
field
Michael, my problem is that I need a filed with precision for a field of
exactly 595 characters! Only text field type with precision is the char
type but its limit is 256 char. I've tried with text type, but precision
were been ignored and my sql silently truncate it at 256 value. I solved
my
If my poor english assists me, I'd like to ask you about how can I import
a lot of small msword files into a mysql table where I've created a column
definied as longblob. I'm using mysql 4.1 and I would avoid to start studing
php or other language at this moment. In other word, my situation is:
1)
First of all I hope you can be patient for my english
I'm working with data import into mysql from a txt file. I'm using LOAD
DATA INFILE
command but I cannot correctly import a text column of 595 characters.
I receive this (very large) file from an external organization and this
file is made