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

Forums | Webyog

Tools to manage and monitor MySQL databases

Don't Understand How One Update In One Row Will Affect Multiple Ro

This topic is empty.

Viewing 1 reply thread

Author

Posts
- February 23, 2010 at 4:04 am #30516
  
  peterlaursen
  Participant
  
  It is explained here:
  
  http://www.webyog.com/faq/content/28/70/en/i-only-changed-one-row-of-data-but-sqlyog-wants-to-update-more-rows-in-the-database-why.html
  
  .. so the WHERE clause mathes that number of rows. To comment further will will need the CREATE statements for the tables as well as the (JOIN-)query you are referrring to.
  
  BTW: Instead of verbose explain it is most often better to paste the SQL – it is non-ambigious and can even be imported/executed at our end.
- February 24, 2010 at 12:34 am #30517
  
  l333h
  Member
  
  Okay, thanks a lot, Peter – both for the answer and the tip. Next time I'll also check the FAQs before I post a question. (This was my first post and I only checked the Forum.)
  
  — Larry
Author

Posts

Viewing 1 reply thread

You must be logged in to reply to this topic.