Description: This application is an example of preventing inserts/updates of a MySQL view that are not visible through this view via WITH CHECK OPTION. In other words, whenever you insert or update a row of the base tables through a view, MySQL ensures that the this operation is conformed with the definition of the view.
Key points:
- add WITH CHECK OPTION to the view
- this application will throw an exception of type java.sql.SQLException: CHECK OPTION failed 'bookstoredb.name_and_genre_view
