MySQL foreach?

Question

I have two database tables, users and logs. I need SQL code to do something in rows

foreach(id in users)
  insert into logs a record with user_id = id;
endforeach;

I could use php to implement foreach, but I decided it was probably a pure SQL way. I am using a MySQL server if this helps.

Answer 1

try a template like this

INSERT INTO logs (blah,blah)
SELECT foo,bar from Users 

You should also read something called Correlated subqueries if you need some type of logical connection between two statements

Answer 2

Try:

INSERT INTO logs (user_id) SELECT id FROM users;

This will give you a clean entry logfor each user id.