Can somebody help me out. How do I input data into a table from a
file. I know the general form is
LOAD DATA LOCAL INFILE "file.txt" INTO TABLE myTable; .
I having problems as to where MySQL is looking for file.txt because
when i use the command above mySQL can't find it. I don't know how to
change the command so mySQL looks in my account.
Thanks
Mitchell