Re: Need help with creating a "look-up" table in MySQL
OK, but this may need to be done once, or done 100 times, depending on the number of custom fields that apply to the product....
Are there any complete examples with source that would maybe give some idea as to how this may work?
I get the idea of what you are suggesting, I'm just trying to apply it where this process can be repeated on the same column, but work its way through the custom fields for a particular device.
So, le'ts say that we first find all rows where custom field #1 = 1. Then we need to go through the table again and find all rows where custom field #1 = 1 AND custom field #2 = 1, and so on. But we want to serach the results found in the first query as results to search for the second query, essentially drilling down as far as we can go until we have searched all custom fields for appropriate matches. Each query will narrow down the results further than the previous query basically.
Subject
Written By
Posted
September 05, 2013 01:26PM
September 05, 2013 05:10PM
September 06, 2013 08:50AM
September 06, 2013 08:52AM
September 06, 2013 10:10AM
September 06, 2013 10:13AM
Re: Need help with creating a "look-up" table in MySQL
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.