1. How to change the order of the fields (together with the values) in one table from A|B|C|D to A|D|B|C ?

2. How to copy one field from one table to another table?

2. How to change the values of a field which previously use unixstamp to datetime. Is there any script or easy way to do that as i have about 1300 rows to change.

Thanks for your help