I have tables like
changes201101
changes201102
changes201103
...
changes201201
And table
whichchanges
which contain rows Year and MONTH
How I can select * from changes from whichchanges
?
I type this query
SET @b := SELECT CONCAT('changes',year,month) FROM whichchanges;
((((@b should contain now multiple rows of changesYearMonth)))))
SET @x := SELECT * FROM @b;
Prepare stmt FROM @b;
Prepare stmt FROM @x;
Execute stmt;
See Question&Answers more detail:os#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT CONCAT('changes',year,month) FROM changes)' at line 1