how to copy one field in mysql

[yahoooh]

hello

i need the query code to :
copy one field from one table to another

i have table name : article with field name @categoryid@
i need to transfer this field with all data to another table named vbarticle

any help

[Dismounted]

Do you want to move the whole table, or just move all category ids over? You've written "transfer this field with all data" so I'm a bit confused.

[yahoooh]

only @transfer this field with all data@
to another table which already created

[Eikinskjaldi]

are the @signs supposed to help us in someway?

Is there a key field? I assuem there must be

update recieve_table, donate_table, set receive_table.receivefield=donate_table.donate_fie ld where receive_table.key = donate_table.key