My litle copy project

[thoand]

I have to copy data from an older table to a new one(where the structure is altered)

My idea is to copy data from the fields which is equal
eg.

old_table.title -> new_table.title
old_table.abstract -> new_table.abstract
old_table.body -> new_table.body

and update the fields which do not exists in the old table :p

is this posible, how?
or is there tool/ way to do this

hope I made myself clear and thanks for tips,

regards Thomas Andersen

[melody]

Not sure what Db you're using, but your best bet it to read the whole old table and write a CSV file using the data in the same order that your new table columns are in. Most databases can then accept a CSV file as an argument and populate the new table for you. Alternatively, if you're using Postgresql, you can use the ALTER TABLE... command to simply alter the old table. There may be a way to do this in other databases too, which is probably worth looking up.

Hope this help,

Melody

[tomhath]

All you need is an insert statement, something like this (not tested):

insert into new_table (title, abstract, body, newcolumn)
select title, abstract, body, 'Data for new column' from old_table