doubledee Posted April 2, 2012 Share Posted April 2, 2012 What is the "name space" for Indexes in MySQL? Can I have an index name "idx_member_id" in both my MEMBER table and in my ANSWER table? Debbie Link to comment https://forums.phpfreaks.com/topic/260212-namespace-for-indexes/ Share on other sites More sharing options...
cpd Posted April 2, 2012 Share Posted April 2, 2012 Indexes are directly related to their tables. If you index something on one table, it wont index that field on another table, you will need to do it yourself. Link to comment https://forums.phpfreaks.com/topic/260212-namespace-for-indexes/#findComment-1333719 Share on other sites More sharing options...
doubledee Posted April 2, 2012 Author Share Posted April 2, 2012 Indexes are directly related to their tables. If you index something on one table, it wont index that field on another table, you will need to do it yourself. So if I have 20 tables, and every table has a field called "something", and on every table I create an Index called "idx_something" then there would never be a "collision" between Indexes?! Debbie Link to comment https://forums.phpfreaks.com/topic/260212-namespace-for-indexes/#findComment-1333730 Share on other sites More sharing options...
cpd Posted April 2, 2012 Share Posted April 2, 2012 Correct. Link to comment https://forums.phpfreaks.com/topic/260212-namespace-for-indexes/#findComment-1333739 Share on other sites More sharing options...
doubledee Posted April 2, 2012 Author Share Posted April 2, 2012 Correct. Okay, thanks! Debbie Link to comment https://forums.phpfreaks.com/topic/260212-namespace-for-indexes/#findComment-1333744 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.