Create table with SELECT syntax in MySQL

Viewed 10471

I would like to know how MySQL interprets the CREATE TABLE syntax:

If I write:

CREATE TABLE tbl1 (
    `v1` int,
    `v2` int
     CONSTRAINT idx PRIMARY KEY (v1)
)
SELECT a, b FROM tbl2;
  • Does it determine which value goes into v1 and which goes into v2 by their order in the select statement?

  • Does it use the names I designate in the CREATE TABLE statement or does it take them from the select statement?

I have used the CREATE TABLE XX SELECT val FROM YY before but would like to know more specifically about the above syntax.

1 Answers
Related