In college, I learned how to program in SQL using Oracle 9i running in window. Now six years later, I am trying to program in SQL using MySql running in Linux Fedora Core 11.
Even though a lot of the basic commands are the same, the way that a user connects to the SQL server and use batch files is different.
In college(Last time used was in 2004):
To log on to the server, I believe we had to edit a file to put our account in.
To run it was @c:\file_name.sql
Example Windows:
@c:\populate_database.sql;
INSERT INTO pet(name,owner,species,sex,birth,death)
LOAD DATA LOCAL INFILE '/path/pet.txt' into TABLE pet;
Whistler Gwen bird \N 1997-12-09 \N
The linux gives an error:
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
I am not sure if I missed anything, please let me know.
Novice Mysql Questions
in Programming
Posted · Edited by ineedcoffee
In college, I learned how to program in SQL using Oracle 9i running in window. Now six years later, I am trying to program in SQL using MySql running in Linux Fedora Core 11.
Even though a lot of the basic commands are the same, the way that a user connects to the SQL server and use batch files is different.
In college(Last time used was in 2004):
To log on to the server, I believe we had to edit a file to put our account in.
To run it was @c:\file_name.sql
Example Windows:
@c:\populate_database.sql;
INSERT INTO pet(name,owner,species,sex,birth,death)
VALUES ('Puffball','Diane','hamster','f','1999-03-30','NULL');
Example MySql from Tutorial
LOAD DATA LOCAL INFILE '/path/pet.txt' into TABLE pet;
Whistler Gwen bird \N 1997-12-09 \N
The linux gives an error:
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
I am not sure if I missed anything, please let me know.
If anyone can suggest a good MySql book.
Thank you.