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: | |
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
[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.