DECLARE id_val  int(11) ;
declare table_lnk varchar(255) ;
select `<column>` into id_val from `<table>` where `<condition>`;
#Create the new table name 
set @create_query = 'CREATE  TABLE  `?` (<column/s> )';
set table_lnk=concat(id_val,'_table');
set @create_query =replace(@create_query,'?',table_lnk);
#Prepare the create table statement 
# preparation is necessary for dynamic table name
prepare create_table_stmt from @create_query;
execute create_table_stmt ;
DEALLOCATE PREPARE create_table_stmt;

DECLARE id_val  int(11) ;
declare table_lnk varchar(255) ;
select `<column>` into id_val from `<table>` where `<condition>`;
#Create the new table name 
set @create_query = 'CREATE  TABLE  `?` (<column/s> )';
set table_lnk=concat(id_val,'_table');
set @create_query =replace(@create_query,'?',table_lnk);
#Prepare the create table statement 
# preparation is necessary for dynamic table name
prepare create_table_stmt from @create_query;
execute create_table_stmt ;
DEALLOCATE PREPARE create_table_stmt;
END

DECLARE id_val  int(11) ;
declare table_lnk varchar(255) ;
select `<column>` into id_val from `<table>` where `<condition>`;
#Create the new table name 
set @create_query = 'CREATE  TABLE  `?` (<column/s> )';
set @create_query =replace(@create_query,'?',table_lnk);
#Prepare the create table statement 
# preparation is necessary for dynamic table name
prepare create_table_stmt from @create_query;
execute create_table_stmt ;
DEALLOCATE PREPARE create_table_stmt;
END

DECLARE id_val  int(11) ;
declare table_lnk varchar(255) ;
select `<column>` into id_val from `<table>` where `<condition>`;
#Create the new table name 
set @create_query = '
CREATE  TABLE  `?` (<column/s> )';
set @create_query =replace(@create_query,'?',table_lnk);
#Prepare the create table statement 
# preparation is necessary for dynamic table name
prepare create_table_stmt from @create_query;
execute create_table_stmt ;
DEALLOCATE PREPARE create_table_stmt;
END

the following code can be used to create a table with a dynamic name

Create a table with a dynamic name

mysql, sql, table

MySQL