CREATE TABLE, INSERT INTO with SELECT in parentheses

[James Fryer]

Assuming a legal SELECT statement, this works fine:

  CREATE TABLE Foo SELECT ...

but this does not:

  CREATE TABLE Foo (SELECT ...)

This is a problem for me as I'd like to use the output of a 
SELECT...UNION...ORDER BY statement as input to CREATE TABLE.

Same holds for INSERT INTO.

Is this a bug? I can't find it documented anywhere.

Jim
--
James Fryer  /  [EMAIL PROTECTED]  /  [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]