Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Syntax Bug

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Syntax Bug

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 24, 2005 at 8:03 pm #9251
      peterlaursen
      Participant

      This SQLyog “template” for CREATE PROCEDURE is 'bugous'

      Code:
      DELIMITER //;
      DROP PROCEDURE IF EXISTS `test`.`myproc`//
      CREATE PROCEDURE `test`.`myproc`()
      BEGIN
      END//
      DELIMITER;//

      According to MySQL documentation correct is

      Code:
      DELIMITER //;
      DROP PROCEDURE IF EXISTS `test`.`myproc`//
      CREATE PROCEDURE `test`.`myproc` ()
      BEGIN
      END//
      DELIMITER;//

      There shall be a blank character between procedure-name and ()

      I haven't come across any situation where it matters. But better do it right!

      MySQL's own so-called GUI programs do that.

    • September 25, 2005 at 4:57 am #19284
      Ritesh
      Member

      Will be fixed in BETA 3.

      We are able to create SPs with that syntax itself 😀

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.