SQL FOR EACH?

Question

I have a table with two columns, userID and contentID. Basically this table is used to assign access to certain content to specific users. I have the request of every user that is assigned to content A also be assigned to content B. So how would I write a new row with this data (userid, [id of content B]) for each row that has (userid, [id of content A])?

OK I tried what the top two posts said and it converted it to:

INSERT INTO tbl_courseAccess
                      (contentid)
SELECT     11 AS Expr1
WHERE     (contentid = 6)

and didn't work, so I'm not sure what I did wrong, here is what I tried to use:

insert into tbl_contentAccess
(userid, contentid)
select userid, 11
where contentid = 6

OK I found a new solution, don't worry about this anymore, thanks everyone.

Answer 1

insert into <table>(userid, contentid)
select userid, [content b id] from <table> where contentid = [content a id]))

Corrected: Typing too fast to race you other answerers

Answer 2

insert into [tablename]
(userid, contentid)
select userid, [id of content B]
where contentid = [id of content A]

Answer 3

    insert into your_table(userid, contentid) select userid, 
[id of content B] from your_table where contentid = [id of content A])

That should do the job.

Answer 4

INSERT INTO mytable (userID,contentID) 
  SELECT userID,[id of content B] FROM mytable 
    WHERE content = [id of content A];