how to copy one field in mysql
 

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

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.

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

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