content_image/730130.jpg content_image/730131.jpg
<img src='content_image/730130.jpg'>

When selecting all columns and using the default column names, you can omit SELECT * , so the statement just used to create table tv1  can also be written as shown here: 

<img src='content_image/730131.jpg'>

When using VALUES  as the source of the SELECT , all columns are always selected into the new table, and individual columns cannot be selected as they can be when selecting from a named table; each of the following statements produces an error ( ER_OPERAND_COLUMNS ): 

CREATE TABLE tvx SELECT (x,z) FROM (VALUES ROW(1,3,5), ROW(2,4,6)) AS v(x,y,z); CREATE TABLE tvx (a INT, c INT) SELECT (x,z) FROM (VALUES ROW(1,3,5), ROW(2,4,6)) AS v(x,y,z); 

Similarly, you can use a TABLE  statement in place of the SELECT . This follows the same rules as with VALUES ; all columns of the source table and their names in the source table are always inserted into the new table. Examples: 

