| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Pubcon Platinum Sponsor 2014|
|SQL staement to change field|
want to update field from a to b
I want to have an sql statement to UPDATE tablexyz.
Select * FROM tablexyz and update field b from the value in field a and override what already exists in field b.
This really belongs in the Database forum.. but ya, are you trying to copy the value in field a to field b? if so you can just simply run a update query like,
UPDATE tablexyz SET field_b = field_a WHERE <any conditions you want matched>
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved