What is the best way to save a list of available colors for a product in mysql? There are lots of products and every product can have more than two colors (ex: clothes color 1, textile color 2, wood color).
I go to the table with table (id_product, id_color) to add product table, color table and then connect them Will happen. This can be more than one color for any product, and you can easily find all the products with the selected color. You can create similar to other features.
But you may want to create a separate table for product attributes (such as for color)
No comments:
Post a Comment