Bug #32925 NEw delimiter for statements in triggers
Submitted: 3 Dec 2007 13:17 Modified: 29 Sep 2009 10:25
Reporter: Olaf van der Spek (Basic Quality Contributor) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S4 (Feature request)
Version:* OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[3 Dec 2007 13:17] Olaf van der Spek 
Description:
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html

Wouldn't it be easier to use a different statement delimiter inside triggers to avoid the need to change the delimiter?

> Use of multiple statements requires that a client is able to send statement 
> strings containing the ;  statement delimiter. This is handled in the mysql 
> command-line client with the delimiter command. Changing the ; end-of-statement 
> delimiter (for example, to //) allows ; to be used in a routine body. For an 
> example, see Section 18.2.1, “CREATE PROCEDURE and CREATE FUNCTION Syntax”.

How to repeat:
-
[29 Sep 2009 10:25] Susanne Ebrecht 
Many thanks for writing a feature request.

Delimiter is MySQL specific and we won't change this behaviour.