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

Incorrect Sql When Updating Table In Join

forums forums SQLyog SQLyog: Bugs / Feature Requests Incorrect Sql When Updating Table In Join

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #35586
      Mitch
      Participant

      Any feedback on this?

    • #35587
      Sibin A S
      Moderator

      Hello Mitch,

       

      The data in the resultset is obtained after executing the query and not from the table.

       

      In the resultset (join of two tables), UPDATE query is fired when you try to modify the value of an existing row. INSERT query is fired in case of a new row is added.

       

      Regards,

      Sibin

    • #35588
      Mitch
      Participant

      I think SQLyog should be smart enough to understand that skuclassificationskuid is the primary key of the sku_classification_sku table, so an update with a null PK doesn’t make sense, so an insert is needed instead.

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