阅读背景:

MySQL查询得到的产品有多种颜色和按颜色数量的产品订购

来源:互联网 

I have one table product(id, name) have n-n relationship with table color(id, name), and 1 table product_color(product_id, color_id). How can i query all product can have multiple color (example i want query product can have color red, green, blue) and order them by number of color coincident( product have 3 color red, green, blue will be first, then product with 2 color and 1 color last)I have one table product(id, name) have n-n rel




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: