Delimiter Issue

[peterlaursen]

Starting from SQLyog 5.17 we do use the same DELIMITER format as the programs from MySQL AB.

Please refer to: http://webyog.com/faq/33_7_en.html

What is the version you are using?

But this:

Quote:

So there must be something non standard going on in SQLYog here.

.. is not true. there is NO STANDARD for the DELIMITER syntax at all! The DELIMITER statement is NOT an SQL statement and it is not sent to the server! It is implemented in the client only. The purpose of the DELIMITER statement is that is shall be possible to distinguish whether a ';' (semicolon) seperates SQL-statements or not. It would be fairly possible for a graphical client to use coloring, indentation, or different fonts or whatever for this!

But we did – after multiple requests – adopt the syntax from MySQL AB in SQLyog 5.17!

[Igor]

peterlaursen wrote on Sep 5 2006, 07:40 PM:

Starting from SQLyog 5.17 we do use the same DELIMITER format as the programs from MySQL AB.

Please refer to: http://webyog.com/faq/33_7_en.html

What is the version you are using?

But this:

.. is not true. there is NO STANDARD for the DELIMITER syntax at all! The DELIMITER statement is NOT an SQL statement and it is not sent to the server! It is implemented in the client only. The purpose of the DELIMITER statement is that is shall be possible to distinguish whether a ';' (semicolon) seperates SQL-statements or not. It would be fairly possible for a graphical client to use coloring, indentation, or different fonts or whatever for this!

But we did – after multiple requests – adopt the syntax from MySQL AB in SQLyog 5.17!

Great, thanks!

Yes, I was using 5.15. I'll certainly download the latest.

I understand that DELIMITER is not a server side command, in fact, hopefully we won't need it soon in MySQL at all, as the parser should get smart enough to not need it. Oracle doesn't use it, SQL Server doesn't use it and they somehow know how to destinguish statements within stored proc vs. ones outside…

Anyway, I am glad you did this as otherwise automatic file deployments through the command line (and this is coming directly from AB, so nothing we can do about this one! :o) ) would be tricky (I was planning on parsing it out before deployment and just have DELIMITERs before and after the whole block of sps, but here you made my life easier, so thanks again!).

Best.

Igor.

[Author]

Posts