MySQL One More Again

[John Nagle]

On 7/16/2010 7:39 AM, MRAB wrote:
> Victor Subervi wrote:
>> Hi;
>> I have the following code:
>>
>> cursor.execute('select MyTable from optionsDetails where Store=%s',
>> (store,))
>> options_tables = [item[0] for item in cursor]
>> for table in options_tables:
>> cursor.execute('select * from %' % table)

    As has been explained to you repeatedly, you're doing it wrong.

    You don't use a relational database to get a field which leads to
another table.  Put the options in one table keyed by Store.

    Go buy a copy of "Databases for Dummies":

http://www.amazon.com/Intranet-Databases-Dummies-Paul-Litwin/dp/0764502212


				John Nagle