Changing directory from which SOURCE reads SQL script files.

2002-12-02 Thread John Connolly
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

LOAD DATA LOCAL INFILE

2002-11-28 Thread John Connolly
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

LOAD DATA LOCAL INFILE

2002-11-28 Thread John Connolly
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;

LOAD DATA LOCAL INFILE

2002-11-27 Thread John Connolly
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