dynamically handle the table

Dear Friends

I am New to Database and developing One Big project in Python. I that
i am facing a situation that I want to dynamically handle the table...
ie..
1. the Table Names are only available at runtime... (because they are
come from another table column.
2. I know that Table's structure.
3. Need to gather results from that unknown table dynamically....

Is any way handle such situation

Very Thanks for your valuable Time.

On 29 Jan, 12:58, "வினோத்" <vinoth...@gmail.com> wrote:
> Dear Friends
>
> I am New to Database and developing One Big project in Python. I that
> i am facing a situation that I want to dynamically handle the table...
> ie..
> 1. the Table Names are only available at runtime... (because they are
> come from another table column.
> 2. I know that Table's structure.
> 3. Need to gather results from that unknown table dynamically....
>
> Is any way handle such situation
>
> Very Thanks for your valuable Time.
Take a look at the SHOW... set of commands.

But i need to buld query from this table name in dynamically....


i know one way building query first. and execute it...

but i need to create records as ordinary records from the resultant
value.


On Jan 29, 6:56 pm, "Captain Paralytic" <paul_laut...@yahoo.com>
wrote:
> On 29 Jan, 12:58, "வினோத்" <vinoth...@gmail.com> wrote:> Dear Friends
>
> > I am New to Database and developing One Big project in Python. I that
> > i am facing a situation that I want to dynamically handle the table...
> > ie..
> > 1. the Table Names are only available at runtime... (because they are
> > come from another table column.
> > 2. I know that Table's structure.
> > 3. Need to gather results from that unknown table dynamically....
>
> > Is any way handle such situation
>
> > Very Thanks for your valuable Time.Take a look at the SHOW... set of commands.

On 29 Jan, 14:13, "வினோத்" <vinoth...@gmail.com> wrote:
> But i need to buld query from this table name in dynamically....
>
> i know one way building query first. and execute it...
>
> but i need to create records as ordinary records from the resultant
> value.
>
> On Jan 29, 6:56 pm, "Captain Paralytic" <paul_laut...@yahoo.com>
> wrote:
>
>
>
> > On 29 Jan, 12:58, "வினோத்" <vinoth...@gmail.com> wrote:> Dear Friends
>
> > > I am New to Database and developing One Big project in Python. I that
> > > i am facing a situation that I want to dynamically handle the table...
> > > ie..
> > > 1. the Table Names are only available at runtime... (because they are
> > > come from another table column.
> > > 2. I know that Table's structure.
> > > 3. Need to gather results from that unknown table dynamically....
>
> > > Is any way handle such situation
>
> > > Very Thanks for your valuable Time.Take a look at the SHOW... set of commands.- Hide quoted text -- Show quoted text -
I'm not sure what you are trying to say here? Can you give an example?

I don't know the Table name
the table names are in one table called tbl_objprop
from that we can retrive the table names.
but I can know the tbl structure....
for E.g...

we have @tbl = 'tbl_valuename' - we know the structure of the table
tbl_valuename but don't know the table name. it is available only at
run rime....

from that table we need to retrive one value.

awe can build one string by this table name and execute it. but it is
very expensive.. as very big table and very high request per/sec......

is any optimzed way to get the table refrence from the string??????


On Jan 29, 7:21 pm, "Captain Paralytic" <paul_laut...@yahoo.com>
wrote:
> On 29 Jan, 14:13, "வினோத்" <vinoth...@gmail.com> wrote:
>
> > But i need to buld query from this table name in dynamically....
>
> > i know one way building query first. and execute it...
>
> > but i need to create records as ordinary records from the resultant
> > value.
>
> > On Jan 29, 6:56 pm, "Captain Paralytic" <paul_laut...@yahoo.com>
> > wrote:
>
> > > On 29 Jan, 12:58, "வினோத்" <vinoth...@gmail.com> wrote:> Dear Friends
>
> > > > I am New to Database and developing One Big project in Python. I that
> > > > i am facing a situation that I want to dynamically handle the table....
> > > > ie..
> > > > 1. the Table Names are only available at runtime... (because they are
> > > > come from another table column.
> > > > 2. I know that Table's structure.
> > > > 3. Need to gather results from that unknown table dynamically....
>
> > > > Is any way handle such situation
>
> > > > Very Thanks for your valuable Time.Take a look at the SHOW... set of commands.- Hide quoted text -- Show quoted text -I'm not sure what you are trying to say here? Can you give an example?