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 INSERT statement lets you enter data into tables and views in two ways: via an INSERT statement with a VALUES (and in MySQL with a VALUES or SET) clause and via an INSERT statement with a query. The VALUES clause takes a list of literal (strings, numbers, and dates represented as strings), expressions (return values from functions), or variable values.

Query values are results from SELECT statements that are subqueries (covered in Chapter 11). INSERT statements work with scalar, single-row, and multiple-row subqueries. The list of columns ...

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