Create generic query for table with generic name

madkitty · #1 (**permalink**) 05-27-11, 05:00

Hi guys,

I have about 20 tables with a generic name like :
table_1
table_2
table_3
table_4
table_5
...
table_20

I need to execute the same query on each table. As I'm a bit tired to copy paste the same thing 20 times in a text file .. Can I do something like a for loop or whatever that does the same and would execute my query

Code:

i=1
for i [1, 20] {
go to table_i ... do the query
i=+1
}

I know it might be confusing .. but it's hard to explain sorry

healdem · #2 (**permalink**) 05-27-11, 05:21

frankly that stinks of bad design
20+ tables with a similar structure

r937 · #3 (**permalink**) 05-27-11, 05:52

Quote:

Originally Posted by madkitty

As I'm a bit tired to copy paste the same thing 20 times in a text file ..

oh, you should have thought of this when you designed 20 identical tables

of course, redesigning them is probably a lot more work than copy/paste, isn't it...

it-iss.com · #4 (**permalink**) 05-27-11, 10:14

Yes it is possible but as the others say it does seem that your design is not ideal. Have a look at stored procedures and in particular to PREPARE, EXECUTE and DEALLOCATE PREPARE which allows you do dynamically create statements.

madkitty · #5 (**permalink**) 05-28-11, 23:14

yeah i know the design sucks but I have no other option. Our data are over 6GB per table, I couldn't figure out any other design so far ..

I'll read more on the prepare/execute/deallocate prepare statements.
Thanks for your help~

Internet Services

Web Development

Digital Marketing

Consumer Tech