MySQL table clause or alias

Question

MySQL table clause or alias

Navigation

#1 by (3 votes)

0

I have a table in MySQL that has a wrong name, this table is already used by many applications, so it would not be very easy to rename it.

Is there any way to create a alias for this table or a clone so that everything done in one is done in the other?

With this new applications would already use the correct name and gradually I can update the old applications.

mysql

asked by anonymous 20.01.2016 / 11:38

1 answer

How to organize BDados results How to open a socket connection?

score 3 · Answer 1

The best solution would be to create a second table with structure identical to the first and work with trigger. Whenever there is insertion, update or deletion in table 1, it will update in table 2. The inverse also needs to occur, after all the new applications will work only with table 2, so their modifications are accurately reflected in table 1.