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
    • December 24, 2015 at 4:35 pm #35586
      Mitch
      Participant

      Any feedback on this?

    • January 8, 2016 at 11:16 am #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

    • January 8, 2016 at 2:34 pm #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.

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