I'm trying to use LOAD DATA INFILE to load a text file into a MySQL db. I've done it once before, but not recently, and I can't remember the entire process.
I currently run the following:
mysql>LOAD DATA INFILE 'updates.txt'
into table fascholarships
fields terminated by "~"
lines terminated by "\n";
I get the following error:
ERROR 1046: No Database Selected
What am I missing? I'm guessing I need to identify what db I'm working with, but I don't remember how.
Thanks.