Bug #22627 Please provide SQL compliant SELECT INTO
Submitted: 23 Sep 2006 10:57 Modified: 13 Oct 2006 14:43
Reporter: Maciej Pilichowski Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S4 (Feature request)
Version:5.0.24a OS:Linux (opensuse 10.0)
Assigned to: CPU Architecture:Any

[23 Sep 2006 10:57] Maciej Pilichowski 
Description:
It would be nice to see MySQL is much more compliant with even basic SQL syntax.

How to repeat:
This is not a bug, just a wish.

Suggested fix:
This is not a bug, just a wish.
[23 Sep 2006 12:57] Valeriy Kravchuk 
Thank you for a feature request. Please, вуыскшиу what exactly do you want to be changed in MySQL's implementation of SELECT ... INTO ...?
[23 Sep 2006 16:51] Maciej Pilichowski 
MySQL is not compliant with SQL right now (I refer to SELECT INTO).

There is one way in SQL to generate table based on select results:
CREATE TABLE T AS SELECT ...

MySQL supports such syntax. However there is another way, from select to table:

SELECT FROM X INTO T ...

and this creates new table. MySQL doesn't support this!

Btw. CREATE-AS is richer because you can specify types and column names, however this should be implemented too.
[13 Oct 2006 14:43] Valeriy Kravchuk 
Thank you for a reasonable feature request.