How to select a table in query as variable in mysql? [duplicate]

Question

I have mutliple tables with same name with added date in the last as abc_2016_09.

Now How can i call this mentioned statement, pls help.

SET @var = concat('ABC_table','_',date_format(curdate(), '%Y'),'_',date_format(curdate(), '%m'));

AND THEN

select * from @var

error code 1069 is coming.

khalid · Accepted Answer · 2016-09-30 11:58:39Z

0

SET @var = concat('abc_table','_',date_format(curdate(), '%Y_%m'));

SET @statment = concat('select * from ', @var);

PREPARE stmt FROM @statment; 
EXECUTE stmt;

Check it in mysql workbench, It does not return row in mariadb.

edited Sep 30, 2016 at 11:58

answered Sep 30, 2016 at 11:18

khalid

1755 silver badges15 bronze badges

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

2 Comments

Ravinder Reddy Over a year ago

date_format(curdate(), '%Y_%m') is much simpler.

khalid Over a year ago

Yes sure...I have edited.

Collectives™ on Stack Overflow

How to select a table in query as variable in mysql? [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related