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
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> ---
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
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 every row in y
>
>
> I've hav