Mysql Create table using Trigger

Question

I have tried to create table inside the Mysql Trigger but not get created. How to create a table using trigger,here Name of the table being passed Dynamic?

Answer 1

As far as I am aware, creating a table inside a trigger is not possible. See here:

http://forums.mysql.com/read.php?99,121849,122609#msg-122609

Also have a look at the Restrictions for Stored Functions section on the Restrictions on Stored Routines, Triggers, and Events page.