MySQL / subquery

[Rodo]

Hi,

INSERT address\_book
SET customers_id = '1260',
entry_country_id = (
SELECT DISTINCT countries_id
FROM countries
WHERE countries_name = 'Austria'
);

ich habe sowas mal so lösen können:
INSERT
 address_book
 (
 customers_id,
 entry_country_id
 )
VALUES
 (
 '1260'
 SELECT ...
 )

http://dev.mysql.com/doc/refman/5.0/en/insert.html

Rodo