MySQL Bugs: #40211: Support for CREATE TRIGGER IF NOT EXISTS

Bug #40211	Support for CREATE TRIGGER IF NOT EXISTS
Submitted:	21 Oct 2008 14:34	Modified:	21 Oct 2008 14:48
Reporter:	Olivier Chédru	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S4 (Feature request)
Version:	5.1	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The syntax "CREATE TRIGGER IF NOT EXISTS" would be very useful, especially when working with MySQL workbench: the generated script contains CREATE TRIGGER statements, and this fails if the same triggers already exist.

How to repeat:
Use MySQL workbench to generate DDL statements dealing with triggers.

Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=15287