CODEWITHSUNDEEP
mysqltriggers
Palani
Palani

Reputation: 1921

Mysql Create table using Trigger

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?

Upvotes: 6

Views: 8453

Answers (1)

Mike
Mike

Reputation: 21659

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.

Upvotes: 8

Related Questions