Stephen Tiano wrote:
Observation: I guess there's no way to just give myself a 'free pass'
to be able to load data into any database. It appears I have to name a
particular database right at the start.
A database is a database; there is nothing _outside_ a database. If you
load the mysql s
At 23:10 -0500 1/21/03, Stephen Tiano wrote:
mysql
Thanks for responding, Paul. What's interesting is that pet.txt was
still "not found" when I used the path as you suggested. What would
be the reason for it being "invisible"?
That that isn't really the correct path. I was just guessing what
mysql
Thanks for responding, Paul. What's interesting is that pet.txt was
still "not found" when I used the path as you suggested. What would be
the reason for it being "invisible"?
Steve Tiano
So I issue the command
LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
and, for the first
At 21:42 -0500 1/21/03, Stephen Tiano wrote:
Okay, I found User Comments at the end of the section of the user
manual online that contained the info I needed to get the option of
loading a textfile into a table.
The startup line I use for that is:
/usr/local/bin/mysql -u root --local-infile
Okay, I found User Comments at the end of the section of the user manual
online that contained the info I needed to get the option of loading a
textfile into a table.
The startup line I use for that is:
/usr/local/bin/mysql -u root --local-infile -p menagerie
where 'menagerie' is the databa