Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

3
  • Really appreciated Matt. This is truly helpful! For those trying to update in phpmyadmin if you leave the id together with the function like this: SELECT id, GROUP_CONCAT(id), name, COUNT(*) c [...] it enables inline editing and it should update all the rows involved (or at least the first one matched), but unfortunately the edit generates a Javascript error... Commented Sep 14, 2015 at 11:25
  • How would you then calculate how many ids are subject to duplication? Commented Jan 17, 2017 at 13:33
  • 3
    How do I not get all the ID's grouped, but instead listed from first to last; with all their respective values in the columns next to them? So instead of grouping it, it just shows ID 1 and its value, ID 2 and its value. EVEN if the values for the ID is the same. Commented Feb 15, 2018 at 9:29