Copy Data within a Table

[bobby13]

HI I was wondering if someone can assist me on how I can copy a collumn within a table into another collumn within the same table.

Basically I have a table called bazes which has a collumn called base_name, within the same table I have inserted a new collumn called official_base_name.

So I want to populate the collumn official_base_name with the data in Base_name, how do I do that I tried....

SQL>update bazes
2 set official_base_name = bazes.base_name
0 rows updated

I also tried...

SQL> insert into bazes (base_name, official_base_name)
2 select base_name, official_base_name
3 from bases
4 where base_name <> null;

0 rows created.

Can anyone suggest a solution?



Regards
Bobby

 

[bobby13]

Problem has been resolved,I had the answer but was using the wrong syntax and making my sql very complicated, when all I needed to do was

update bazes
set official_base_name = base_name;

The new collumn was automatically updated.

Regards
Bobby

 

[SantaMufasa]

Bobby,

Your first code set is the set that you want. The problem is, you have no rows in that copy of your bazes table. You can confirm this with:

select count(*) from bazes;

Let us know,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]