Mysql update multiple columns with select

Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions.

Question feed. Stack Overflow works best with JavaScript enabled. The following example updates the domain parts of emails of all Sales Reps with office code 6 :.

For example, in the customers table, some customers do not have any sale representative. To do this, we can select a random employee whose job title is Sales Rep from the employees table and update it for the employees table. PHP that runs the first query, extracts the values and then creates the update statement. For the closest postcodes couldn't you just use pythag's to work out the closest ones? James-C thanks. The code in the 'where' statement narrows the search down quickly and the 'order by' fine tunes it.

I tried it with just the Pythagerous in the 'order by' and it was very slow 1. Anytime I see a table with columns that have 1-up counters after their names, I get concerned.

Chris Morgan Chris Morgan 2, 16 16 silver badges 19 19 bronze badges. But this OK as it only needs to be done once, and the subsequent database queries that need this information need it fast. The decision on whether or not something is a bad idea virtually always depends on the context. 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. Podcast Making Agile work for data science. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more.

Asked 12 years, 5 months ago. Active 4 years, 3 months ago. Viewed k times. Juan Mellado Add a comment. Active Oldest Votes. Himanshu Jansari FYI - this doesn't work in oracle. Field1, s. Field2, list of fields Gambrinus 2, 16 16 silver badges 26 26 bronze badges.