LOAD DATA INFILE via bash script?
trying to do a LOAD DATA INFILE via a bash script using the follwowing syntax
mysql -u USER -pPASSWORD DATABASE < LOAD DATA INFILE '/path/textFile' INTO TABLE TABLENAME FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' IGNORE 0 LINES (column1,column2,column3)
error received: syntax error near unexpected token `(c'
so, is it possible to do this via a bash script? where am i going wrong here?
Subject
Written By
Posted
LOAD DATA INFILE via bash script?
April 08, 2005 11:35AM
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.