useful-qry/table-controls/backup.sql

set @table := concat('bak_company', '_', date_format(curdate(), '%y%m%d'),'_',time_format(current_time, '%H%i%s'));
set @qry1 := concat('create table ',@table, ' select * from dbr_company');
prepare run_query from @qry1 ;
execute run_query ;