ID #1037

The "DELIMITER" command does not have effect. Why is that?


Before SQLyog version 5.17 we used a DELIMTER format like

Delimiter | ;

and not only

Delimiter |

That was unlike the MySQL command-line client, but the difference was because of the general difference of a command-line tool and a graphical editor. With a graphical editor a linebreak is "parsed away" so you must somehow tell the system that end-of-statement has been reached. You did that with the old delimiter. So the 'mysql' command line client (and other programs from MySQL AB) would not execute SQLYog DELIMITERs and vice-versa.

However from SQLyog 5.17 both formats are supported (and the 'short' one is default). We complete rewrote the parser/tokenizer component of SQLyog to enable this, so this issue should not occur anymore.


Categories for this entry

Tags: -

Related entries:

You can comment this FAQ