Re: can't read file into a table
> MySQL can't just go fetch a file from a URL like that. You need to
> specify the local path /in the filesystem/ where the file resides.
> Something like:
>
> LOAD DATA LOCAL INFILE '/home/foo/pet.txt' INTO TABLE pet;
>
Thanks for looking at my problem - I have 2 MySQL accounts, one with
Panix.com and this new one with Network Solutions - In the Panix terminal
window I have no problem using this LOAD DATA..... command
for some reason Network Solutions is Fubar !
|