MySQL Forums
Forum List  »  Newbie

related tables automatically
Posted by: patridp Cas
Date: May 30, 2014 04:50PM

Hi, All!!

Please, I`m a new in this theme! and I need some help with a problem:


I have a data base and a big table with 8 fields, and now i need to create a new table only with 3 fields, in that all the fields will be records automatically from the big table. I means that if i delete or create a new user in the big table, so, I could have also this change in the new table.

I tried this with related tables and foreign keys, but I donĀ“t have the records.
Please, help me! How can I do that?

Thanks for all!

Patricio

Options: ReplyQuote


Subject
Written By
Posted
related tables automatically
May 30, 2014 04:50PM


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.