MySQL INSERT Query
- by mouthpiec
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?