SQL query question - Copy a column from one table to another

[cinq]

How can this be done ?

Background:
One table, articles_article has already been created, with rows having the first column articles_articleid, being the unique id for each row.

I want to create another table, articles_newtable with exactly the same number of rows with each row having the same corresponding articles_articleid.

How can this be achieved ?
Thanks in advance :)

[Xenon]

that way should work:


INSERT INTO articles_newtable (articleid)
SELECT articles_articleid FROM articles_article

so you see you can mix up insert an select queries :)

[cinq]

I never knew that ! Thanks Stefan :D

[Xenon]

you're welcome

[Michael Morris]

A similar technique can be used to copy table contents over within or even between databases.

create table destinationdatabase.newtable
select * from sourcedatabase.oldtable

You don't have to specificy databases if making a transfer within the same database.

[Xenon]

hey, that one was even new to me :)

you see you can learn more every day..

[Dean C]

This is an enlightening thread :)