Mysql update with outer join

Tables get joined based on the condition specified. You may also have a look at the following articles to learn more —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy. Thats perfect Bill. I can see I had the basics in place..

I don't know how you nailed it so quickly. I couldn't figure out what I wanted to join on. Kind of naive but how about this? Savas Vedova 5, 2 2 gold badges 26 26 silver badges 43 43 bronze badges. Run Explain before you query and the problem is obvious. Rahul Sharma 2, 2 2 gold badges 26 26 silver badges 38 38 bronze badges. Sunil Sunil 1. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The Overflow Blog. As they are new categories, we'd like to add a prefix to the filename of their pictures so that we can be easily identified as new categories. The prefix we're going to add is 'new-' without the single quotes so the picture names will be changed to below.

All the matching rows in the right hand side of the JOIN clause that is the Categories table are also returned in the result. Here is what the result would look like for the left join before an update is run. Here is the update query by using left join. We can use b. Happy Coding!