SQL Update help
Posted
by Cyborgo
on Stack Overflow
See other posts from Stack Overflow
or by Cyborgo
Published on 2010-06-08T22:52:29Z
Indexed on
2010/06/08
23:12 UTC
Read the original article
Hit count: 276
sql
I have a really simple question, is it possible to update a table with new values using just one update statement.
Say for example I have a table with author, title, date, popularity. Now I got some new data which has author name, title corresponding new popularity. How do I update the table now in one statement. Note that author and title are not unique.
© Stack Overflow or respective owner