How to store the quantity of goods?

Question

MySQL

Hello!
There is a table with products
products
- id
- name
And a table with colors
colors
- id
- name
- img
Some products may have several colors. And others may have no color at all. Where and how to store the quantity of such goods? That is, the quantity of goods of a certain color and the quantity of goods without color. I would like to keep everything in one place.
Thank you!

Answer 1

Create 3rd table product_colors:
id
product_id
color_id
It would be wrong to do so.
Why, it is said here: https://habrahabr.ru/post/193756/

Answer 2

That is, the quantity of goods of a certain color and the quantity of goods without color

Separate table name color price. More specifically, product_id color_id price to make selections faster.
And there is one more feature. Without color - this is also a color that will have its own ID

Answer 3

Products?
Then store receipts (batch) and expense (write-offs), and calculate quantities.