WG: Problem with "INSERT ... SELECT"

send table definitions and copy of statement and error message.
It seems like an error in a smal detail.


mit freundlichen Grüßen

Thomas Treffehn

Hans Brochier GmbH & Co KG

Abteilung S2 - Informationswesen
Marthastraße 16
90482 Nürnberg

Fon: +49 0911-9543-355
Fax: +49 0911-9543-383
www.brochier.de

----- Weitergeleitet von Thomas Treffehn/BROCHIER/DE am 12.04.2005 10:2=
0
-----
|---------+--------------------------->
| | "Billy Yard" |
| | | | s.com> |
| | |
| | 12.04.2005 00:00|
|---------+--------------------------->
>----------------------------------------------------------- ---------=
------------------------------------------------------------ -|
| =
|
| An: "MySQL Win32 List" =
|
| Kopie: =
|
| Thema: Problem with "INSERT ... SELECT" =
|
>----------------------------------------------------------- ---------=
------------------------------------------------------------ -|




According to the online manual, the syntax is:
INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name [(col_name,...)]
SELECT ...
[ ON DUPLICATE KEY UPDATE col_name=3Dexpr, ... ]
This syntax shows that multiple fields are allowed however when I try t=
o
execute the statement:insert master1backup (code, track, title, artist
)select (code, track, title, artist ) from mainmasterI get the error
"Operand should contain 1 column(s)". Why am I getting this error?=



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org