Re: Need help with creating a "look-up" table in MySQL
Having several rows for a particular product or device is fine. That's not so much a problem.
The problem that I still see with the layout proposed is what if I need to have 2 custom fields to determine a product. The proposed layout (from my interpretation) would assume 1 device + 1 custom field = 1 product.
What if I need multiple custom fields to determine a single product?
This query would work fine if it was just one custom field:
SELECT * FROM LookupTable WHERE device_id = 300 AND custom_field_id = 1 AND custom_field_value = 'STD';
But in many cases, more than one custom field would need to be checked in a single query.
Subject
Written By
Posted
September 05, 2013 01:26PM
September 05, 2013 05:10PM
September 06, 2013 08:50AM
September 06, 2013 08:52AM
Re: Need help with creating a "look-up" table in MySQL
September 06, 2013 10:10AM
September 06, 2013 10:13AM
September 06, 2013 12:19PM
September 06, 2013 12:52PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.