By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 941 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Is it possible to make auto updating sub tables?

P: 3
I wanted to use MySQL for storage of login information. Then I will have multiple services (RADIUS, Proxy, etc) checking against the information.
Is there a way to make a master table that will have all the information that is needed, then have a bunch of child tables that have the redundant information from the master table, however, only for the particular service. For example I want a table that only has login that is allowed to use the Proxy included, so the proxy looks at only that table, instead of the master table.
Which so far doesn't seem out of reach, however, I would like the children table to update passwords, etc when ever they change on the master table, so I only have to update the master table.
I think I could do what I need if there was a way to save query, so that when the Proxy server looks it thinks its a table and runs check against the results of the preloaded query.

Hopefully I explained what I wanted clearly enough.
Oct 13 '15 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.