Foreach in sql with static data
- by phenevo
Hi,
I have 3 tables:
Countries:
Code, Name
Vacances:
id(autoincrement),CountryCode, NameOfCountry, numberOfdays
How to foreach country insert Row:
countryCode,'Welcome in " + nameofCountry +"!",12