Oracle Database 11g & MySQL 5.6 Developer Handbook

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 ...