updating automaticaly a table

[Guest]

I have two tables in my db :table1 and table2. Both has the same structure.
When table1 is manually updated I want to have table2 updated too
automaticaly. Is this possible ?

 

[Joseph Meehan]

I have two tables in my db :table1 and table2. Both has the same
structure. When table1 is manually updated I want to have table2
updated too automaticaly. Is this possible ?

It's possible, but why do you have two tables with apparently the same
data? And exactly what are you updating (data or file structure)?

 

[Guest]

First, I would ask why you want 2 identical tables? The db would not be
normalized, and you are already facing the most basic problem with this:

How to make sure all the data is updated, to match...

My recommendation would be to simply reduce the db to a single table.

Sharkbyte