how to use a value from sql result as table name for its sub query? [duplicate]

Question

In my application I want use dynamic table name.

In my application I have two queries.

1) SELECT `table_name` FROM `data_tables` WHERE `table_id`="1"

From this query I get a table name and I am saving it in a variable; for e.g: $tab

I have another query:

2) SELECT * FROM `'.$tab.'`;

I want to know is there anyway to club these queries? Is it a good practice?

My application is currently working fine, but I would like some insight.

You can do it using a combination of PREPARE and CONCAT(). But it's the MySQL equivalent of eval() so no, I wouldn't call it good practice — DaveRandom
– DaveRandom, Commented Dec 12, 2013 at 14:29

Andrii Horda · Accepted Answer · 2013-12-12 14:32:13Z

0

DECLARE @Name varchar(max)
SELECT @Name =`table_name` FROM `data_tables` WHERE `table_id`="1"
SELECT * FROM `@Name`

answered Dec 12, 2013 at 14:32

Andrii Horda

1901 silver badge18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1