Trigger in Mysql for movie rentals?

Asked

Viewed 281 times

2

I need a little help because the teacher said not to use FUNCTIONS and PROCEDURES, ONLY the TRIGGER. It follows image of what he is asking. I’m really not able to do. For me there had to be before a FUNCTION where it checks whether the ID of the inserted movie is in the rental table and check the return date from it. If it is larger than 0000-00-00 can rent, but the TRIGGER returns message warning that the movie is rented.

inserir a descrição da imagem aqui

mysql database trigger
  • 4

    Put the code you’ve already made and the error you’re making.

No answers

Browser other questions tagged mysql database trigger

You are not signed in. Login or sign up in order to post.