Hi all:
Using script files is convenient because it allows storage of
frequently used queries, and facilitates editing long queries without
having to retype the whole thing.
Something that would make script files more convenient is to change
the directory from which SOURCE reads them.
My
Hello all ---
I posted this yesterday, perhaps before my subscription took effect,
and so I am not sure that it got distributed. So, forgive the
repetition in sending, if that's the case. Anyway . . .
Here's the question, as succinctly as I can formulate it:
The documentation seems to
Victoria and Michael:
Thanks very much.
Following on your suggestions, I then went ahead and put the text file
into my directory:
/usr/local/mysql
so that the file was then /usr/local/mysql/absence.txt
and, with that done, the
LOAD DATA LOCAL INFILE absence.txt into table absence;
Here's the question, as succinctly as I can formulate it:
The documentation seems to say that one can load a tab-delimited text
file located in the current directory of the client host into a
database by running the client mysql and executing the following
command:
mysql LOAD DATA