foreach(): Invoke a script on each element of given collection. $() is a synonym of this routine.
Select multiple columns; execute multiple queries based on those columns:
I think this is the same as cursormysql> call foreach( "SELECT Code, Name FROM world.Country WHERE Continent='Europe'", "DELETE FROM world.CountryLanguage WHERE CountryCode = '${1}'; DELETE FROM world.City WHERE CountryCode = '${1}'; DELETE FROM Country WHERE Code = '${1}'; INSERT INTO logs (msg) VALUES ('deleted country: name=${2}');");
0 comments:
Post a Comment