homepage Welcome to WebmasterWorld Guest from 54.226.43.155
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
SQL staement to change field
want to update field from a to b
weddingm




msg:4085721
 5:28 pm on Feb 23, 2010 (gmt 0)

I want to have an sql statement to UPDATE tablexyz.

Basically:

Select * FROM tablexyz and update field b from the value in field a and override what already exists in field b.

Thanks,
Matt

 

Zipper




msg:4085743
 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>
weddingm




msg:4085751
 6:24 pm on Feb 23, 2010 (gmt 0)

awesome, thanks!

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved