Skip to Content
Former Member
Apr 10, 2008 at 11:36 AM

Addition of fields to database table and copying data from other field


Hi All,

I am having a database table where in I am having a column 'FIELD1'.

My requirement is that I want to add two more fields in the table 'FIELD2' and 'FIELD3'.

I then want to copy all the data in field1 to field2 and field3. then I want to delete the original field1.

for Ex.

lets say FIELD1 = 100.

now I want to add FIELD2 and FIELD3 in the table and make FIELD2 = 100 AND FIELD3 = 100. The FIELD1 will be deleted from table.

Please suggest the methods to do so.

It is urgent.