Sponsored By

Sign in to follow this  
ineedcoffee

Novice Mysql Questions

Recommended Posts

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.

Edited by ineedcoffee

Share this post


Link to post
Share on other sites

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.

mysql on Linux takes the same commands as on windows.. I'm confused on why you would think its different.


mysql> Drop table Inventory;

mysql> CREATE TABLE Inventory
-> (
-> ID SMALLINT NOT NULL PRIMARY KEY,
-> InStock SMALLINT NOT NULL,
-> OnOrder SMALLINT NOT NULL,
-> Reserved SMALLINT NOT NULL
-> );
Query OK, 0 rows affected (0.06 sec)

mysql> INSERT INTO Inventory VALUES (101, 10, 15, 4),
-> (102, 1, 9, 3),
-> (103, 5, 2, 13);
Query OK, 3 rows affected (0.01 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> select * from Inventory;
+-----+---------+---------+----------+
| ID | InStock | OnOrder | Reserved |
+-----+---------+---------+----------+
| 101 | 10 | 15 | 4 |
| 102 | 1 | 9 | 3 |
| 103 | 5 | 2 | 13 |
+-----+---------+---------+----------+
3 rows in set (0.01 sec)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this