MySQL Forums
Forum List  »  Triggers

Re: How to convert oracle scripts to mysql
Posted by: lokesh kumar
Date: May 03, 2012 04:31AM

Hi Peter,

Thank you for the reply.
The code you have provided is working for 'BEFORE' inserting the recording into the table. It is not working for 'AFTER' inserting the record into the table.

Below is the code

DELIMITER $$
CREATE TRIGGER ecidb.HASHPASSWORD_PARENT BEFORE INSERT ON ecidb.employee
FOR EACH ROW
BEGIN
SET NEW.password = md5(NEW.password);
END;

It is working fine

Regards,
Lokesh

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to convert oracle scripts to mysql
1203
May 03, 2012 04:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.