Bug #82475 duplicate values in column
Submitted: 5 Aug 2016 13:40 Modified: 3 Feb 2018 10:25
Reporter: mike coutinho Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:6.3.10 OS:Any
Assigned to: CPU Architecture:Any

[5 Aug 2016 13:40] mike coutinho
Description:
When looking at a result set, I find myself looking to make sure that there are no duplicate values a lot. If my join is incorrectly done, the primary key will show up more than once.  For me to find this quickly, I have to do a couple things like making a sub select with a count or any number of things.  

It would be really handy to right click on a column and turn on an option for just that column that shows duplicate occurrences of that value in the data set.  This would highlight the cells that are in there multiple times with a color.  Nothing more. It would most likely reset itself with subsequent selects. 

How to repeat:
See description

Suggested fix:
See description
[3 Feb 2018 10:25] MySQL Verification Team
Hello mike coutinho,

Thank you for the feature request!

Thanks,
Umesh