Hi,
LOAD DATA restricts only on BLOB,TEXT,ENUM and FIXED DATA. Others are
equally supported [INSERT stmt]. Likewise for mysqlimport also.
If the data file has no delimiter other than space[even the name,
addresss,etc contain spaces], then the target table will not the one what is
expected,
In the last episode (Nov 17), John Kopanas said:
> On 11/17/06, Dan Nelson <[EMAIL PROTECTED]> wrote:
> >In the last episode (Nov 17), John Kopanas said:
> >> I have a text file with over 500K rows of data in it. The problem
> >> is that the data is no seperated by commas but instead occupy a
> >>
I am trying to figure out how this would work? How does LOAD DATA
figure out when one column begins and another ends when some of the
data are addresses with spaces in them?
On 11/17/06, Dan Nelson <[EMAIL PROTECTED]> wrote:
In the last episode (Nov 17), John Kopanas said:
> I have a text file
In the last episode (Nov 17), John Kopanas said:
> I have a text file with over 500K rows of data in it. The problem is
> that the data is no seperated by commas but instead occupy a certain
> amount of characters. So for instance:
>
> ID 1 -11
> NAME 12-50
> COMPANY_NAME 51-100
> ...
>
> How
I did a little shell script to do it. the key was the shell variable IFS:
Normally IFS=" "
to make it work right I set it as follows:
IFS="
"
Yes, thats a newline between the quotes
John Kopanas wrote:
I have a text file with over 500K rows of data in it. The problem is
that the data is