MySQL INSERT Query
Posted
by mouthpiec
on Stack Overflow
See other posts from Stack Overflow
or by mouthpiec
Published on 2010-03-31T21:55:38Z
Indexed on
2010/03/31
22:03 UTC
Read the original article
Hit count: 208
Hi,
I need a query to perform the following: find the countryID where country = 'UK' from table Countries
then use the found value in
INSERT into towns (id, country_fk, name)
values (1, <value_found>, 'London').
is this possible?
© Stack Overflow or respective owner