Hi!
On Aug 14, James Fryer wrote:
> 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.
It's in the 4.0.14 changelog, and thus, is available in 4.0.14
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
