Keyboard shortcuts

Press or to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

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.