Sponsored By

ineedcoffee

Members
  • Content Count

    1
  • Joined

  • Last visited

About ineedcoffee

  • Rank
    Member
  1. ineedcoffee

    Novice Mysql Questions

    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.