updating values

• sandeep4testing

  Mr or Mrs. 500

  Points: 534

  More actions

  March 20, 2012 at 12:44 am

  #252968

  Hi frinds,

  In my database employee table contains six columns like eno,ename,....., Now i suppose to create one duplicate table for employee instead of all columns i taken 3 columns for duplicate columns like below

  select * from employee

  select eno,ename,job into employee1 from employee

  select * from employee1

  Now in duplicate table i added commotion column

  alter table employee1 add comm int

  Now commotion column contains null values

  now i want to add commotion values which are having in base table commotion fields

  How any one can tell me ?

  thank's

  Sandeep.

• March 20, 2012 at 2:23 am

  This was removed by the editor as SPAM

• sandeep4testing

  Mr or Mrs. 500

  Points: 534

  More actions

  March 20, 2012 at 6:23 am

  #1461562

  Hi Stewart,

  It is working, Thanks for ur quick reply.

  Thank's

  Sandeep.