RE: Insert row in x for every row in y

insert into group_map (user_id, group_id) select distinct user_id , from user ; -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 10:52 AM To: [EMAIL PROTECTED] Subject: re: Insert row in x for every row in y Zabel, Monday, November 18

re: Insert row in x for every row in y

Zabel, Monday, November 18, 2002, 6:35:06 PM, you wrote: ZI> I've having trouble figuring out the SQL to do this. ZI> I have two tables, user, and group_map, and I want to insert a row into ZI> group_map for every row in user. ZI> user ZI> ZI> user_id ZI> group_map ZI> ---

RE: Insert row in x for every row in y

On 18 Nov 2002, at 12:03, Adam Nelson wrote: > insert group_map (user_id,group_id) select user_id,"6" as any_label from > user There's no need for any_label in that query, since you're not using it for anything: INSERT group_map (user_id, group_id) SELECT user_id, 6 FROM user; -- Keit

RE: Insert row in x for every row in y

You can use insert group_map (user_id,group_id) select user_id,"6" as any_label from user > -Original Message- > From: Zabel, Ian [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 18, 2002 11:35 AM > To: [EMAIL PROTECTED] > Subject: Insert row in x for ev

Insert row in x for every row in y

I've having trouble figuring out the SQL to do this. I have two tables, user, and group_map, and I want to insert a row into group_map for every row in user. user user_id group_map user_id group_id For each user_id: insert into group_map ( user_id, group_id )