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:

[sql]
INSERT INTO articles_newtable (articleid)
SELECT articles_articleid FROM articles_article[/sql]

so you see you can mix up insert an select queries

[cinq]

I never knew that ! Thanks Stefan

[Xenon]

you're welcome

[Michael Morris]

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

[sql]create table destinationdatabase.newtable
select * from sourcedatabase.oldtable[/sql]

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