Procedure question

[QatQat]

Hi there,

here is the problem:

I have a table that contains, in a column, names of other tables. What i need to do is to write a procedure that, looping through all values (table names) in that column, executes a query against all tables that are listed

How to achieve this?
Procedure?


QaTQat

--------------------------------------
If I could have sex each time I reboot my server, I would definitely prefer Windoz over Linux!

 

[hoinz]

Have a look at Prepared Statements

http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-prepared-statements.html