O'Reilly logo

Oracle Database 11g & MySQL 5.6 Developer Handbook by Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image

image

he UPDATE statement lets you change data in tables and views by resetting values in one or more columns. A single UPDATE statement can change one, many, or all rows in a table. The new values can come from literal values, variables, or correlated query results. Correlation is the matching of one set of data with another through join operations. This chapter discusses equijoin (equality value joins); Chapter 11 examines join options in detail.

Oracle and MySQL implement basic UPDATE statement syntax in a similar way, but Oracle supports a record ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required