-
HELP - Moving data across columns
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 in a different table.
Thanks in advance for you help
Cheers
-
Yes,
You can use INSERT INTO table1.. SELECT .. FROM table2
to copy data from one table to another.
-
Thanks. Thats a great help
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|