Duplicate a field in database

Question

HI 
 
 I am trying to duplicate a field in database table along with data Can any one suggest me how to do this?

Abhishek Karumuru · Answer

hi appiand5477 you can do using this statements 
 ALTER TABLE your_table
ADD COLUMN new_column_name datatype;

UPDATE your_table
SET new_column_name = old_column_name; 
 
 But just wanted to know actual requirement why are you trying to duplicate data. It may not be best practice sometimes

Harshit Bumb (Appyzie) · Answer

Update table set newfield=oldfield

Duplicate a field in database

Top Replies