Bug #2307 | INSERT SELECLECT documentation | ||
---|---|---|---|
Submitted: | 7 Jan 2004 7:47 | Modified: | 7 Feb 2004 7:54 |
Reporter: | Will Read | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Websites: MySQL.com | Severity: | S3 (Non-critical) |
Version: | 4.0 | OS: | Windows (Windows 2000) |
Assigned to: | Assigned Account | CPU Architecture: | Any |
[7 Jan 2004 7:47]
Will Read
[7 Jan 2004 7:53]
Dean Ellis
The column list is optional provided you select enough values for all columns, just as with a normal INSERT.
[7 Jan 2004 7:54]
Paul DuBois
Please show the statement that failed and the error message you received, and show the statement that succeeded. The column list is optional, but the statement will certainly fail if the number of columns in the table is not the same as the number of columns produced by the SELECT.
[14 Feb 2005 22:54]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".