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?
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With