Copying with SQL

[1510982]

A simple question, I assume.
I'm looking for a solution with two tables that are with one-to-one relationship.

Patients
id | name | lastname

Heights
id | height

Now, I have already filled in the Patients table, but on the contrary Heights table is empty. Now I would want to copy all the Patients.id values to Heights.id. How would that be possible using SQL? Thank you for your answer.

 

[fluteplr]

insert into heights (id) select id from patients.

Note: This assumes that the height field either has a default or will accept a null value.

 

[petersJazz]

If height is not null column you can use:

insert into heights select id,175 from patients