mysql cascades on update

[jackvull]

Hi
I have a table that holds exchange rates. What I would like to happen is that if this table is updated, it automatically has an update cascade that updates 2 or 3 other tables and updates prices accordingly.
Is this possible in mysql?

[jackvull]

i have mysql 4 so I'm not sure a trigger will work?

[txbakers]

not in 4. Possible in 5.

In 4 you have to write the cascades yourself.