I need to create a Mysql Trigger to create a table with the name containing the id of the last row inserted in another table

Question

I would like every time a row was inserted into the chats table,

a new table was created. The Table must have the name of the value inserted in the chat_id column of the chats table.

Ex: If the last id inserted is 34, the table should be called chat_34

I tried to create Trigger for after there is an Insert in the chat_id table

CREATE TRIGGER `create_chats_table` AFTER INSERT ON `chats` FOR EACH ROW 

SELECT chat_id INTO @chat_id_ FROM chats ORDER BY chat_id DESC LIMIT 1;
SELECT CONCAT('chat_', @chat_id_) INTO @table_name_;

CREATE TABLE IF NOT EXISTS @table_name_  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `message` TEXT,
    `author` varchar(20) NOT NULL,
    `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT  @table_name_ FOREIGN KEY (id) REFERENCES chats (chat_id) ON DELETE CASCADE,
    PRIMARY KEY (`id`)
  ) ENGINE  = InnoDB;

The problem is when I try to create, the following message appears in the terminal:

O nome da entidade era esperado. (near "@table_name_" at position 27)

It seems that Mysql is not recognizing the variable I am using on this line

CREATE TABLE IF NOT EXISTS @table_name_ (

How can I make my Rigger work? What I’m doing wrong?