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.
Subject
Written By
Posted
How to load text or sql file into mysql commandLine?
October 27, 2007 07:50AM
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.