MySql equivalent of a for-each loop

Question

I am a total MySql noob. I have two tables, Computer and Technician. Computer has a foreign key of techID which associates it with a particular Technician entry and indicates which Technician last serviced a computer. Basically I want list the last technician to service every computer.

I thought to do something like:

SELECT techID FROM Computer

My issue is that for each techID in my result set, I want to grab the technician's name out of the Technician table and return that instead. Basically I wondering how to query and achieve the same result as something like:

results = SELECT techID FROM Computer
for-each(r in results){
    SELECT name FROM Technician WHERE techID = r.techID
}

this question sounds like you are trying to learn SQL just by "google, copy paste code and go..."... Go through some basic tutorial at least, if not school course. SQL needs change of thinking. — Tomas
– Tomas, Commented Apr 25, 2012 at 21:51
I am not trying to learn SQL at all. I'm just trying to get one simple task done and be done with it. I'm a Mongo guy. — user1022241
– user1022241, Commented Apr 25, 2012 at 22:01
That comment is like saying you want to multiply two numbers, but you can't be bothered to figure out how to use a calculator. If SQL were like rocket science I might see the point of not wanting to learn it, and if you were a beginner, I might see the point of this question. But the point of your question isn't that you don't know how to do it, it's that you don't want to spend time finding out (aka "TeH coDEZ"). The task is, as you rightly remark, simple, so why not just learn how to do it? — toon81
– toon81, Commented Oct 16, 2012 at 8:05

Roland Bouman · Accepted Answer · 2012-04-25 21:41:00Z

2

Use a JOIN:

SELECT     Computer.id, Technician.name
FROM       Computer
INNER JOIN Technician
ON         Computer.techID = Technician.techID

This should give you a list of each computer with the matching technician.

answered Apr 25, 2012 at 21:41

Roland Bouman

32.1k8 gold badges69 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

MySql equivalent of a for-each loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related