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

Spreadsheet / Table Control Makes Silly Sql

forums forums SQLyog SQLyog: Bugs / Feature Requests Spreadsheet / Table Control Makes Silly Sql

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • #23520
      peterlaursen
      Participant

      Ok now I understand!

      When updating SQLyog updates every column in the grid. There is no logic in the grid to 'remember'

      that a row is printed there twice.

      With this query

      SELECT a.id, a.name, a.* …

      it happens as you describe it. Why do you need to “SELECT a.id, a.name” explicitly when you “SELECT a.*” ??

      Do you know any graphical grid-type database client doing otherwise?

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