Load from Data File You have an error in your SQL syntax
By: DiigIT | 14 Jun 2010 8:07 pm | 190 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.
Which SAP Course, Module do I select for my Career in SAP?Many people come to me and they say that which SAP module is best for me? This is a very common Question for a person who is new to SAP and want to make their career in SAP.If some one asks this Question from me then I first ask about their Educational and Professional Background because this is...
SAP said 'No' to our Offer for Partnership, says Salesforce CEOWe attempted to collaboration with a competitor, says Marc Benioff.Marc Benioff, CEO, Salesforce, in an interview to Bloomberg this Thursday, has confirmed that SAP (Systems, Applications, Products) has rejected their offer of collaboration. Bloomberg reports that in spite of having worked...
How's Big Data Dealing with 'Big Brother' Data Privacy IssuesThere is a new buzzword in the world of Big Data, one that talks about the privacy issues related with the “big brother”. This is specifically true with regards to the processes linked with the accumulation, analysis and mining of Big Data. It’s fortunate that quite a few of these rumors, and...
Bill McDermott Recovering Well, To Continue As SAP's CEOSAP Chief Executive officer Bill McDermott is on a road to recovery though he may have suffered irreversible damage to his eye after the fall in July this year. Bill McDermott, 54 plans to be back in Germany hopefully by next month. As reported by German Magazine WirtschaftsWoche, McDermott...
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...
Error in SQL: ORA-27102: out of memory
Hello DBAs,Do you guys provide me any help regarding my following problem:SQL> startup nomountORA-27102: out of memoryPlease solve my problem if anyone is familiar with it.Thanks in Advance!
An Introduction to Federated Portal Network (FPN)
To give you an idea, why the concept of FPN has been established, letâs start with a simple portal setup: one central portal exists inside a company. The general idea of an enterprise portal is...
SAP launches data migration services
SAP AG will offer customers a new data migration service to shift data from disparate applications into a SAP enterprise resource planning (ERP) infrastructure. The services, which will use data...