Copy data from one field to another???

Hi

I have two databases of which I need to copy data from one to another.

I have copied the complete table over named it product 1, the other table being product. What I now need to do is copy the data from the 15th field of product 1 into the 4th field of products. I am stumped! I did think (not for long!!) that I would just do it by hand - but nearly 1250 lines of data would take a month of sundays!! Can anyone help me at all?? I would be extremely grateful for any pointers as my SQL coding has already been maxed out!! Thanks in advance (I hope!)

Can anyone tell me what is wrong with the following? Should it just be update and set?

ALTER TABLE 'products1' ADD 'tempcol' decimal AFTER `products_small_description;
UPDATE 'products1' SET tempcol =`products_rrp`;
ALTER TABLE 'products1' DROP 'products_rrp1';
ALTER TABLE 'products1' CHANGE tempcol `products_rrp1` decimal;