How can i select a table dynamically from mysql

Question

Is there any option to select a table dynamically from mysql..

For example,

If i have 3 tables like

t_tableconfig contains data like,

tableid  tablename
1         t_2013
2         t_2014

t_2013 contains

id     name
1      David

t_2014 contains

id     name
1      joe

If I will pass a table name as a parameter.. Can I view the records from specified table? Please advice me

score 1 · Answer 1 · edited May 23 '17 at 11:49

1

It depends on what your programming language or ORM(Object-relational Mapping).

Could you please tell me the environment you're using to query sql statement?

// I've added below

As you said you're using hibernate, I hope the link below can help you. I'm not familiar with hibernate.

edited May 23 '17 at 11:49

Community

answered Dec 21 '13 at 05:13

Hosang Jeon

As you said you're using hibernate, I hope the link below can help you. I'm not familiar with hibernate. http://stackoverflow.com/questions/8573468/hibernate-data-object-with-a-dynamic-table-name-by-annotations – Hosang Jeon Dec 21 '13 at 08:47

Imran · Answer 2 · 2013-12-21T09:23:30.580

Use redbeans ORM . it's awesome ORM. you can change your table dynamically. You can perform crud operation which you usually use in several tools.

Advantage

You can create schema more faster.
Magically perform [CRUD](http://en.wikipedia.org/wiki/Create,_read,_update_and_delete) operation
That has only 1 php file. It has no criteria to installation.
Easy to learn