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

Hanging temporary hang due to timeout

forums › forums › SQLyog › Using SQLyog › Hanging temporary hang due to timeout

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • April 12, 2004 at 3:54 pm #15659
      CalEvans
      Member

      Hi,

      A)

      There is no NOOP command in SQL.

      I guess they could determine what database you are connected to and select * where 1=2 but that's really troublesome.

      I've already put in a request for an auto-reconnect and re-select the database I was last in. I've been told that they are considering it. This would do the trick. (I have 1 server I work with that has a 2 minute disconnect! It really gets annoying after a while)

      In the mean time, I've worked around this problem by adding databasename. to each of my table names in my from clause. I'm never exited about having to change my habits to work around flaws in a tool but SQLyog is a very important tool for me and it's still the best out there for mysql. So I begrudgingly work around it.

      HTH,

      =C=

    • April 13, 2004 at 4:10 pm #15660
      jpipes
      Member

      Hey, thanks a bunch for the post

      I was aware that there was no NOOP command in SQL ( 😉 ), but thought it might serve to illustrate the situation better…

      Thanks again!

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