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.
SAP ABAP Syntax (All from A to Z)
ADD for single fieldsAdds two single fields.SyntaxADD <n> TO <m>.The contents of <n> are added to the contents of <m> and the results are stored in <m>. This is...
File management with SQL Server
With the restructuring of hardware or with a lack of space, you may need to change or create individual database files or all database files for the SQL Server. This note describes the file...