Questions tagged as 'trigger'

How can I delete a record being inserted into a specific condition in a trigger? example: USE 'scompraslenovo'; DELIMITER $$ CREATE TRIGGER 'precad_fornecedor_BUPD' BEFORE UPDATE ON 'precad_fornecedor' FOR EACH ROW BEGIN IF (new.f1 IS N...

I have to do a trigger, where to be excluded an employee will also be excluded its dependent. But I can not exclude. the code looks like this: delimiter $ create trigger TRG_excluiDependente_AD after delete on Funcionario for each row begin...

Well, I have a table called LOCALAOBOOK in it I have BOOK and CUSTOMER information when an insert or update of allocation occurs, so the customer_id, id_id, the output_data will be informed and from this date the delivery_date_date will be gener...

I have a trigger that checks if the login of the user has more than 3 characters and if it does not have it returns msg "login must have more than 3 characters", how can I capture this return in java and show in a Joptionpane? with try catch(...

I am developing a property system and I need every five minutes the bank to read the information of the property, process and decrypt the information, send a confirmation of processing and discard the information. I'm thinking of doing some trig...