copying columns???????

[blade_in_exile]

is it possible to copy one coumn from within a database table to another table with in the same database, i am using sql 4.1

[ronverdonk]

Something like

UPDATE table_xx, table_yy 
SET table_xx.count=table_yy.number 
WHERE table_xx.id=table_yy.id;

where you update the column `count` in `table_xx` with the values from column `number` in table `table_yy` as long as columns `id` in both tables match?

Ronald :cool:

[blade_in_exile]

is there anyway to do with without the WHEREE claus as its a new table i am copying into and have nothing to reference it against

[ronverdonk]

Assuming that you have created a table_y with an auto-increment key:

insert table_y (name) select name from table_x;

Ronald :cool: