MySQL Forums
Forum List  »  Newbie

How to load text or sql file into mysql commandLine?
Posted by: John seito
Date: October 27, 2007 07:50AM

I have a question, I want to be able to load data such as a text.file or sql.file into mysql. I know the code is

LOAD DATA LOCAL INFILE "addresses.txt" INTO TABLE phoneList;

or if i want to create an sql database without typing it in mysql comandline but in an sql.file

SOURCE buildphoneList.sql;

but where do I store these txt and sql file for Mysql commandline to know to load these information. I tried many things and it has not work for me.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.