In oracle database, we can use substitution variable to dynamically create table, user...etc.

My requirement is to achieve the same thing in mysql database.

How to achieve this??