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

Unpredictable SQL execution

forums › forums › SQLyog › Using SQLyog › Unpredictable SQL execution

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • April 30, 2003 at 1:39 pm #14186
      CalEvans
      Member

      Jim,

      Are there any sql commands in the window that are not terminated by a ;? SQLyog is very picky that ALL commands must be terminated by a ; if there are multiple commands in the window, EVEN IF IT'S NOT A COMMAND YOU ARE EXECUTING. Not sure why but check it out. This would explain why closing and reopening would cause it to work.

      BTW, this most commonly hits me when I use ENTER to view the contents of a table. In 3.11 it puts a ; on the line BEFORE the command to make sure that any command there is properly terminated (I guess) but it does NOT terminate the select with a ;. Therefore If I do this and then try and type in a command below it I will get an error in my sql and to fix it I simply terminate the SELECT with a ;.

      Clear as mud?

      HTH,

      =C=

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.