Insert table values from another table

[ToeKnee2]

Hi,

I have two tables: Users and metadata

Users:
id
userid
username


Metadata:
id
userid
value

I would like to extract a list of the userid's from the users table and enter them into the metadata table, with an additional value.

Example:
I want to take all of the userid's from the User table and insert them into the Metadata table, and make the value="one" for each entry into the Metadata table.

Could someone point me in the right direction please?

Thanks,

Tony

 

[r937]

INSERT 
  INTO Metadata
     ( userid
     , value )
SELECT userid
     , 'one'
  FROM Users

r937.com | rudy.ca

 

[ToeKnee2]

Great,

Thanks