SQL Class Exercise: Table Administration

                  
0. Create a table named TractorImplement from these column definitions:
   Column Name                 Type          Constraint
   --------------------------- ------------  -----------------------------
   article                     varchar(21)   primary key
   msrp                        decimal(6,2)  
   category                    char(7)
   quantity                    int(1)



	
	
1. Issue a show create table command for TractorImplement.


    
2. Load TractorImplement with data from a file named implement.csv .



3. Query TractorImplement.


4. Rename TractorImplement to Implement.


5. Alter Implement to drop the primary key.


6. Add a column named id, data type int, unsigned, not null with the 
   auto_increment type attribute and designated the primary key. [Place id
   first in left-to-right sequence.]




7. Change the name of the msrp column to price.



8. Modify price to set the width to 7 and the precision to 2 decimal places.



9. Use the show command to display the Implement table definition.

    
implement.csv   
Box Blade-4 ft,429.99,grader,7
Cultivator,224.99,tillage,5
Finishing Mower-5 ft,1379.00,cutter,5
Finishing Mower-6 ft,1599.00,cutter,8
Landscape Rake,469.99,utility,4
Middle Buster,138.62,tillage,0
Post Hole Digger-6 ft,449.99,utility,2
Rear Blade-5 ft,319.99,grader,5
Rotary cutter-4 ft,749.99,cutter,0
Rotary Tiller-4 ft,1449.00,tillage,6
Rotary Tiller-5 ft,1499.99,tillage,4
Seeder Spreader,379.99,planter,3
Sub-Soiler,179.99,tillage,3
Trailer Mover,168.65,utility,4
Wire Roller,319.99,utility,0