@lists.mysql.com
Subject: Re: Load data infile and text fields
Date: Sun, 10 Apr 2005 02:32:28 +0200
Cc: [EMAIL PROTECTED]
Am Samstag, 2. April 2005 13.51 schrieb [EMAIL PROTECTED]:
First of all I hope you can be patient for my english
I'm working with data import into mysql from a txt file
Am Samstag, 2. April 2005 13.51 schrieb [EMAIL PROTECTED]:
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
@lists.mysql.com,
[EMAIL PROTECTED]
Subject: Re: Load data infile and text fields
Date: Mon, 4 Apr 2005 15:52:06 -0400
Stefano,
I'm copying this to the mailing list. I think it is a lot better if we
have
discussions of this kind on the mailing list so that others can also learn
from them, either
Hello.
Do you use a VARCHAR type for that column? It's maximum
length is limited to 255 characters. I think, switching to TEXT type
could solve the problem.
[EMAIL PROTECTED] wrote:
First of all I hope you can be patient for my english
I'm working with data import into mysql
documents. Each record should have a single word file.
I'd like to write a query (I hope without using api as php or other languages)
that imports automatically all .doc files stored ina dir. Have any idea?
Thanks
Stefano
-- Messaggio originale --
Subject: Re: Load data infile and text fields
From
[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 12:24 PM
Subject: Re: Load data infile and text fields
Rhino, many thanks for your answer! 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
On Apr 4, 2005, at 3:52 PM, Rhino wrote:
Stefano,
I'm copying this to the mailing list. I think it is a lot better if we
have
discussions of this kind on the mailing list so that others can also
learn
from them, either now or in the future via the mailing list archive.
I'm glad to hear that you
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
What is the structure of the table you are importing to? you might have
merely hit the natural limit of the column type.
- michael dykman
On Sat, 2005-04-02 at 06:51, [EMAIL PROTECTED] wrote:
First of all I hope you can be patient for my english
I'm working with data import into mysql
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, April 02, 2005 6:51 AM
Subject: Load data infile and text fields
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
10 matches
Mail list logo