DIGIT-ARC read-only archive · snapshot: July 23, 2026

Help! Sql: copy values from one field to another in the same table

2 posts · originally from https://geek.digit.in/community/threads/help-sql-copy-values-from-one-field-to-another-in-the-same-table.125194/

phuchungbhutia
phuchungbhutia Original post #1
Mar 19, 2010 at 7:47 AM
I have a db table where i have fields like name , desig, section basic, bassup, etc. What i want to do is copy all the value under bassup and insert into basic, keeping he same table structure. How cn i do so, help me.
Zangetsu
Mar 19, 2010 at 9:50 AM
I have a db table where i have fields like name , desig, section basic, bassup, etc. What i want to do is copy all the value under bassup and insert into basic, keeping he same table structure. How cn i do so, help me.

its simple...

update [db table name]
set basic = bassup

;-)