Skip navigation links

MySQL Forums :: Triggers :: How to convert oracle scripts to mysql


Advanced Search

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
How to convert oracle scripts to mysql 2087 lokesh kumar 04/27/2012 03:21AM
Re: How to convert oracle scripts to mysql 1035 irek kordirko 04/27/2012 03:22PM
Re: How to convert oracle scripts to mysql 989 lokesh kumar 05/02/2012 06:02AM
Re: How to convert oracle scripts to mysql 812 Peter Brawley 05/02/2012 08:27PM
Re: How to convert oracle scripts to mysql 787 lokesh kumar 05/03/2012 04:31AM
Re: How to convert oracle scripts to mysql 764 Manoj Bardhan 05/03/2012 10:13PM


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.