On Thursday 26 September 2002 11:16 pm, Jeremy Zawodny scribbled something
about:
> On Thu, Sep 26, 2002 at 11:24:14AM -0700, Gary Traffanstedt wrote:
> > sql,query
> >
> > I have a table that has approximately 40 colums and all but 1 of
> > them I have been able to
On Thu, Sep 26, 2002 at 11:24:14AM -0700, Gary Traffanstedt wrote:
> sql,query
>
> I have a table that has approximately 40 colums and all but 1 of
> them I have been able to make fixed width. The sole hold out is of
> the type "TEXT" and needs to be able to hold approx
sql,query
I have a table that has approximately 40 colums and all but 1 of them I have
been able to make fixed width. The sole hold out is of the type "TEXT" and
needs to be able to hold approximately 1000 characters. The reason why I want
it to be a fixed width field is for
Damned filter. Anything quoted once is my post. Grrr...
> database,sql,query,table
> Erica Douglass writes:
>
> > I have a text file that is fixed-width delimited (that is, fields are
> > delimited by certain column widths.)
> >
> > What is the workaround for
I have a text file that is fixed-width delimited (that is, fields are
delimited by certain column widths.) I have encountered the problem listed
in the manual entry for LOAD DATA INFILE as:
Fixed-size rows (FIELDS TERMINATED BY and FIELDS ENCLOSED BY both empty)
and BLOB or TEXT columns
phiLLip maDDux II writes:
> Hello,
>
> I am working on loading data into a table from a text file. I've read
> the documentation on the LOAD DATA command. But I noticed that it only
> works with some kind of delimited file. Is there any way to load a
> fixed width file
Hello,
I am working on loading data into a table from a text file. I've read
the documentation on the LOAD DATA command. But I noticed that it only
works with some kind of delimited file. Is there any way to load a
fixed width file???
Thanks in advance!
ph
