Auto fill in mysql

[Namnai Kidorkar]

say i've two tables. they both have 2 columns in common. Is there anyway, that each time i update those two columns in table one, table two gets updated as well? how about updating with different informatin such as lengh of table 1 column 1 goes to table2 column 1. thanks in advanced.

[Paul Sturrock]

You could do this with triggers. Alternatively, if you have shared data you could store this in a seperate table and refer to it from each existing table.