Re: How to convert oracle scripts to mysql

[lokesh kumar]

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