469,963 Members | 1,241 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,963 developers. It's quick & easy.

copying columns???????

is it possible to copy one coumn from within a database table to another table with in the same database, i am using sql 4.1
Aug 7 '06 #1
3 1487
4,258 Expert 4TB
Something like
Expand|Select|Wrap|Line Numbers
  1. UPDATE table_xx, table_yy 
  2. SET table_xx.count=table_yy.number 
  3. WHERE table_xx.id=table_yy.id;
where you update the column `count` in `table_xx` with the values from column `number` in table `table_yy` as long as columns `id` in both tables match?

Ronald :cool:
Aug 9 '06 #2
is there anyway to do with without the WHEREE claus as its a new table i am copying into and have nothing to reference it against
Aug 11 '06 #3
4,258 Expert 4TB
Assuming that you have created a table_y with an auto-increment key:
Expand|Select|Wrap|Line Numbers
  1. insert table_y (name) select name from table_x;
Ronald :cool:
Aug 11 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Rebecca Lovelace | last post: by
4 posts views Thread by Gordon Burditt | last post: by
2 posts views Thread by Stefan Schneider | last post: by
1 post views Thread by Mark Smith | last post: by
5 posts views Thread by Nathan Sokalski | last post: by
2 posts views Thread by Rick Palmer | last post: by
1 post views Thread by byrd48 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.