Inserting to selected table name

Question

I have got a table called Aliases in my MySQL database.

Looks like this:

------------------
| Id    | Alias  |
------------------
|1      | 'TabX' |
------------------
|2      | 'TabY' |

...    

|       |        |
------------------

And I need to insert to those tables like this:

INSERT INTO (SELECT Alias FROM Aliases WHERE id=1) (somevalue) VALUES (value);

This doesn't work. Please help.

Answer 1

You can reach it with prepared statements:

SET @alias = (SELECT Alias FROM Aliases WHERE id = 1);
SET @sql = CONCAT('INSERT INTO ', @alias, ' (somevalue) VALUES (value)');
PREPARE stmt1 FROM @sql;
EXECUTE stmt1;