MySQL Forums
Forum List  »  Perl

creating triggers via perl script
Posted by: Michael Gargiullo
Date: November 16, 2006 10:33AM

I create a table dynamically in a perl script. I'd also like to create a trigger at the same time for that table...

my $createTableQuery="CREATE TABLE EventEngineRule".$rule_id." (EventID bigint(1) unsigned NOT NULL, TimeStamp datetime NOT NULL) ENGINE=Memory";

my $dbCreateTrigger="DELIMITER | CREATE TRIGGER CheckForAlert After INSERT ON EventEngineRule".$rule_id." FOR EACH ROW DO CALL CheckRuleAll(".$rule_id."); | DELIMITER ;";

Any idea how to accomplish this?

Options: ReplyQuote


Subject
Written By
Posted
creating triggers via perl script
November 16, 2006 10:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.