MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: UPDATE Table 1 with JOIN Table 2
Posted by: Peter Brawley
Date: July 28, 2015 10:50AM

Your Update statement will try to update every joined doc_may2015_2_narrow row, is that the requirement?

If you're running 5.6.3 or later run Explain Extended on your update query to see what optimisations are needed. Otherwise run Explain Extended on a Select version of the query.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
UPDATE Table 1 with JOIN Table 2
kate willson
July 27, 2015 10:22PM
Re: UPDATE Table 1 with JOIN Table 2
Peter Brawley
July 28, 2015 10:50AM
Re: UPDATE Table 1 with JOIN Table 2
Rick James
August 02, 2015 10:30AM
Re: UPDATE Table 1 with JOIN Table 2
kate W
August 02, 2015 06:20PM
Re: UPDATE Table 1 with JOIN Table 2
Peter Brawley
August 02, 2015 08:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.