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! Link to comment https://forums.phpfreaks.com/topic/9073-pointers-in-mysql-possible/ 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. Link to comment https://forums.phpfreaks.com/topic/9073-pointers-in-mysql-possible/#findComment-33402 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.