Loops in MySQL alone

Question

I'd like to select from one table and use the results of that select to update another table, but only based on certain conditions. Is this possible with a 1-time SQL query?

Do you want us to just say "yes" in an answer??? Perhaps you'd like to flesh out your question a bit more. — Gerrat
– Gerrat, Commented Feb 11, 2011 at 20:51
Yes it's possible. Can you give a concrete example? Otherwise you'll probably just get a link to the manual which some contains examples. — Mark Byers
– Mark Byers, Commented Feb 11, 2011 at 20:51

Mchl · Accepted Answer · 2011-02-11 20:52:50Z

2

Yes it is.

UPDATE
  tableToUpdate AS ttu
[LEFT|RIGHT|INNER] JOIN
  otherTable AS ot
ON 
  joinCondition
SET
  ttu.field = ot.field
WHERE
  conditionsToBeMet

AS otherTable you can just use the SELECT query that you use to fetch your resultset.

answered Feb 11, 2011 at 20:52

Mchl

62.4k9 gold badges121 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Loops in MySQL alone

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related