| Welcome to WebmasterWorld Guest from 18.104.22.168 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Pubcon Platinum Sponsor 2014|
|SQL staement to change field|
want to update field from a to b
| 5:28 pm on Feb 23, 2010 (gmt 0)|
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.
| 6:03 pm on Feb 23, 2010 (gmt 0)|
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>
| 6:24 pm on Feb 23, 2010 (gmt 0)|
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