After searching many forums, I think my problem is how to enter the question correctly, because I cannot find the answer remotely close to what I need, but I think it is excel> mysql 101 in appearance. .
I have an excel sheet with dozens of types of blinds (for windows). There is a row that is width .. and a left column that is height. When you go to the link for width and height (for example, 24 x 36), it matters the price.
| 24 | 30 | 32 | 36 (width)
----------------------------
24 | $50 $55 etc
30 | $60 etc etc(price)
32 | $70
(height)
I cannot figure out for life where and how I should import this into mysql when my database looks like this.
itemname_id <<(my primary) | width | height | price
Am I doomed to manually enter thousands of combinations or is it common? How to introduce the right conditions for finding a solution? Obviously, I'm not talking about proper jargon.
. , .