Duplicating Columns on same table

Wrox Programmer Forums

		Wrox Programmer Forums > Database > SQL Language
Duplicating Columns on same table

SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

May 11th, 2004, 03:34 AM

yuvalk

yuvalk is offline

Authorized User

Join Date: Nov 2003

Posts: 30

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Duplicating Columns on same table

Hi All,
I want to duplicate one column to another on the same table.
Any idea ?

Thanks

Yuval Kronenfeld
Web Developer

__________________
Yuval Kronenfeld
Israel

Old

May 11th, 2004, 05:44 AM

Jeff Mason Jeff Mason is offline

Jeff Mason is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 839

Thanks: 0

Thanked 1 Time in 1 Post

Default

Code:

UPDATE yourtable
    SET dupcolumn=sourcecolumn;

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Old

May 11th, 2004, 06:22 AM

yuvalk

yuvalk is offline

Authorized User

Join Date: Nov 2003

Posts: 30

Thanks: 0

Thanked 0 Times in 0 Posts

Default

no i understand why im considered a "starting member" :)
Thank you:)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Fixed table columns	darkhalf	HTML Code Clinic	1	August 27th, 2008 02:05 AM
first 10 columns in table	vijayma	SQL Server 2005	4	July 18th, 2007 09:08 PM
Sort Table Columns by Table Header Attribute	omrieliav	XSLT	4	June 7th, 2006 01:05 AM
XSL dynamic columns in a table	Himansu Behera	XSLT	1	July 1st, 2004 08:14 AM
merging 2 columns in the same table	comet	SQL Language	3	July 17th, 2003 08:13 AM