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:

Last update: 2006-09-06 23:10
Author: Peter Laursen
Revision: 1.3

{writeDiggMsgTag} {writeFacebookMsgTag} {writePrintMsgTag} {writeSend2FriendMsgTag} {writePDFTag}
{translationForm}
Rate this FAQ

Average rating: 3.5 (2 Votes)

completely useless 1 2 3 4 5 most valuable

You can comment this FAQ