How list matching fields and Update in MySQL


I would like to aggregate SKU based on matching BASE SKU to generate the blue colmun. I would like to have the SQL code update this table to SET the GROUP column, not just show it temporarily.

I’ve ben trying everything from GROUP_CONCAT to loop but having no success. Can you please help? Thank You.

Source: mysql

Leave a Reply