Is there an easy way to copy data from one column to another within the same table?

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Carl Federl One Orange Chip Points: 25384 More actions · Answer 1

If the columns are in the same table:

Update MyTable

set MyNewColumn = MyOldColumn

if the columns are in different tables:

Update MyNewTable

set MyNewColumn = (select MyOldColumn from MyOldTable where some criteria )

SQL = Scarcely Qualifies as a Language

Betty Sun SSCrazy Points: 2442 More actions · Answer 2

Carl,

That works (same table data). Thank you so much.

You know what I tried as follow before I saw your post.

update myTable set myNewColumn=(Select myOldColumn from myTable where ...)

it didn't work says that subquery have multiple values.

Betty

venkat-216866 SSC Veteran Points: 257 More actions · Answer 3

update a set a.MyNewColumn = b.MyOldColumn from table1 a , table2 b where a.<keyfield> = b.<keyfield>

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 4

I'm in a picky mood today

Don't use this old legacy syntax:

update a set a.MyNewColumn = b.MyOldColumn from table1 a , table2 b where a.<keyfield> = b.<keyfield>

Use ANSI syntax instead:

update a set a.MyNewColumn = b.MyOldColumn from table1 a JOIN table2 b ON a.<keyfield> = b.<keyfield>

/Kenneth

Nathan Bosworth Grasshopper Points: 15 More actions · Answer 5

Grasshopper

Points: 15

November 29, 2005 at 4:19 pm

Is there an easy way to do this in sybase ISQL???

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 6

SSC-Dedicated

Points: 30043

November 30, 2005 at 2:11 am

Have you tried the ANSI syntax in Sybase?

/Kenneth