Insert into concat("table", "name")

[John Noble]

Hi there,

Im trying to write an event where I dont know the name of the table in advance but it will be something like tableName2017 where 2017 is the current year.

I have tried:

INSERT INTO CONCAT("tableName", YEAR(CURDATE())) (f1, f2)
SELECT f1, f2 FROM table2;

without success. If I remove the CONCAT syntax and hardcode the tablename then it works fine.

Any ideas ??

J