MySQL Forums
Forum List  »  Triggers

Triggers in MySQL 3.23
Posted by: Bharati Raul
Date: June 12, 2006 11:58PM

Can I used triggers or foreign key in MySQL 3.23 version.

If not, then is their another way to do it?

What I want is:
---------------
I have a table which has all the details about product like creation date, name, desc, visible_status, and expiry date.

If product's expiry date = today's date, then visible_status flag automatically change in same table as well as related table also.

How can I do this?

Thanks in advance...
- Bharati

Options: ReplyQuote


Subject
Views
Written By
Posted
Triggers in MySQL 3.23
2678
June 12, 2006 11:58PM
1657
June 13, 2006 06:56AM


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.