mysql

[Antman]

Hallo Andreas,

INSERT INTO translation1 (lang, keyval, trans)
(
SELECT 'de',keyval,de FROM translation WHERE (de NOT IS NULL)
UNION
SELECT 'en',keyval,en FROM translation WHERE (en NOT IS NULL)
UNION
SELECT 'fr',keyval,fr FROM translation WHERE (fr NOT IS NULL)
UNION
SELECT 'it',keyval,it FROM translation WHERE (it NOT IS NULL)
UNION
SELECT 'es',keyval,es FROM translation WHERE (es NOT IS NULL)
UNION
SELECT 'el',keyval,el FROM translation WHERE (el NOT IS NULL)
UNION
SELECT 'nl',keyval,nl FROM translation WHERE (nl NOT IS NULL))

Gibt den Fehler:

MySQL meldet:
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'IS  NULL  )
UNION
SELECT  'en', keyval, en
FROM translation
WH