Moving data between columns

[john434]

Hi

I've recently inherited a database at work, containing all sorts of data relating to students at a college.

Someone has gone nuts, on this DB and created loads of unnecessary columns. Most of them i can simply delete, though some have got relevant information in them.

Is there a way i can copy this data across to a different column so i can streamline the system somewhat.

Thanks in advance for you help

Cheers

 

[MartijnTonies]

UPDATE mytable
SET mycolumn = myothercolumn



Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server

http://www.upscene.com

 

[john434]

cheers mate thats just the ticket.

Thanks for your help