Load from Data File You have an error in your SQL syntax
By: DiigIT | 14 Jun 2010 8:07 pm | 293 times viewed | 0 Comments
I tried using the load data command from the book and kept getting an error. I know how to run it in the Oracle in windows, but not in Mysql in Linux.
The Code and the Error:
mysql> LOAD DATA INFILE /home/errol/pets.txt INTO TABLE pet;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/home/errol/pets.txt INTO TABLE pet' at line 1
/home/errol is the path.
pets.txt is the file.
If I was running Oracle in windows, I would have used what they taught in class. We created one run file that would create the database, populate the database, and then run the queries.
The Code in the run file:
I am not sure what I am doing wrong.
No Comments Posted for this Article.
Working in an SAP production environment with OWB
SAP is a bit different... it is more structured than most other environments and there are specific requirements on running ABAP programs in production systems. Since this is a common topic, and...
Dynamic File selection in Info package
1)File will be given to you on every day with date attached to it at the end. 2)Info package should detect the file automatically and load the data at the end of the day. Solution:- 1) File...