Professional Web Applications Themes

dynamically handle the table - MySQL

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....

  1. #1

    Default 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.

    வினோத் Guest

  2. #2

    Default Re: dynamically handle the table



    On 29 Jan, 12:58, "வினோத்" <com> wrote: 
    Take a look at the SHOW... set of commands.

    Captain Guest

  3. #3

    Default Re: dynamically handle the table

    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" <com>
    wrote: 

    > [/ref]

    வினோத் Guest

  4. #4

    Default Re: dynamically handle the table



    On 29 Jan, 14:13, "வினோத்" <com> wrote: 
    > [/ref]
    > [/ref]
    > [/ref][/ref]
    I'm not sure what you are trying to say here? Can you give an example?

    Captain Guest

  5. #5

    Default Re: dynamically handle the table

    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" <com>
    wrote: 



    > [/ref]
    > [/ref]
    > [/ref]
    > [/ref][/ref]

    வினோத் Guest

Similar Threads

  1. Question create column in table dynamically
    By saidujjama in forum Brainstorming Area
    Replies: 0
    Last Post: May 11th, 09:05 AM
  2. Trying to insert link into a table dynamically
    By davd_b in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: July 31st, 11:08 PM
  3. Handle Event of Dynamically Added User Control
    By Jon B in forum ASP.NET Building Controls
    Replies: 5
    Last Post: April 30th, 12:33 PM
  4. Dynamically generating multi-table SQL
    By J. Gleixner in forum PERL Miscellaneous
    Replies: 7
    Last Post: July 17th, 04:08 PM
  5. dynamically creating table
    By Rick Walsh in forum ASP.NET General
    Replies: 1
    Last Post: July 11th, 02:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139