ChrisB: INSERT und SELECT bei mysql

Beitrag lesen

Hi,

INSERT INTO adress_new (email, name1, name2, name3) VALUES(SELECT EMAIL, NAME1, NAME2, NAME3 FROM adress WHERE gruppe = '2' or gruppe ='3')

Geht aber nicht.
Wie wärs richtig?

RTFM: http://dev.mysql.com/doc/refman/5.5/en/insert-select.html

MfG ChrisB

--
Autocomplete has spoiled me to a point where it happens every so often that I encounter a CAPTCHA, and I just type in the first character … and then wait for the rest of the code to be automatically suggested :/