Class Exercise:  File Operations(SQL)

                    
1. Login to an interactive interface for SQL.

2. Use the create command to define a table(file) named Staff.
   The column names, data types and lengths are described below:
    
   Table Name  Column Name  Data Type  Length  Comment/constraint
   ----------  -----------  ---------  ------  -------------------  
   Staff:      id           int             3  primary key
               name         varchar        15  not null
               office       char            7
               fee          decimal       7,2  default 0.00
               reviewDate   date          ---





3. Start a "transaction" that may be committed("saved") or rolled back ("undo").


4. Use insert commands(or load utility) to store data rows into Staff.
   load data local infile 'd:/path.ext' into table staff 
   [fields terminated by ','];
   
    
5. Select (project) all column data from Staff. 


6. Modify the staff table data with the following operations:  
   a. Delete that row where the id is = 705;


   b. Use update to set the office to 'JO 235' for that with id=876;



   c. Apply an insert to set id=864, Name='Harter', Office='JO 212', and
      fee=4343.43 in a new row for Staff;


   d. Select all data from Staff, then rollback your changes.      
   
   
   
6. Issue a select command to retrieve staff data in order by ReviewDate.



7. Delete all data from staff and drop the table.



8. Exit the SQL interactive environment.


* Data for the Staff Table(id,name,office,fee,reviewDate):
  033,Huerter,JO 210,3579.13,2013-11-2
  428,Suh,JO 207,4567.80,2013-12-20
  533,Brown,JO 238,3838.38,2013-12-23
  705,McWhorter,JO 218,2975.31,2013-12-15
  803,Creider,JO 122,7272.72,2013-12-19
  876,Saffer,JO 122,5775.33,2013-12-19