Exercise MySQL

  1. Create a user with a password manually.
  2. Create a database manually.
  3. Create a table manually for describing fleet of cars: id, license-plate, year-built, brand, owner. (Owner is the name of the owner)
  4. Create a program that accepts values on the command line and insterts the data in the database
  5. Create another program that lists all the cars.
  6. Improve the selector program to accept command line paramter --minage N and --maxage N and show the cars within those age limits (N is a number of years e.g. 3)
  7. Create program to delete a car.
  8. Create program to change the owner of a car.