JustinK101 Posted May 4, 2006 Share Posted May 4, 2006 Is it possible to have a field in mysql that simply points to another field in a completely different table? So, for example:table1 field: first_name | varchar(50)table2 field: first_name | table1.first_nameThat way when the field in the other table gets modified the field in the new table gets updated automatically. This would be very useful for me. Thanks! Quote Link to comment Share on other sites More sharing options...
ober Posted May 4, 2006 Share Posted May 4, 2006 I'm unsure why you would want to do something like that. Storing the same data in 2 places means that your database isn't normalized.However, you could create a VIEW that would meet your criteria. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.