Assignment#1 - Some hints regarding how to use mysql on the NYU
servers. 

NOTE: This is just for testing purposes for you.
All you hand in is the SQL that will
produce the answers to the questions of assignment 1, assuming
the data is already loaded.

1. Create a SQL file with queries to create tables and insert data into table as given in the handout.

2. copy your SQL file to cims. Note your source&target path may be different.

	>> scp ~/FILENAME.sql YOUR_NETID@access.cims.nyu.edu:~

3. Connect to MySQL server and run your SQL file to load data in the database

	>> source YOUR_FILEPATH/YOUR_SQL_FILENAME.sql

5. Then check if your tables are created properly

	>> show tables; 

			MySQL [loadhw1]> show tables;
			+-------------------+
			| Tables_in_loadhw1 |
			+-------------------+
			| Course            |
			| Employee          |
			+-------------------+
			2 rows in set (0.01 sec)

	>> select * from Course;
	>> select * from Employee;

6. If you made changes and need to re-execute the SQL file. You may first drop previously created tables.


If you have questions, please contact yc3798@nyu.edu