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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.