Request into several databases simultaneously on TML
Prefix
Also as tables in DDL and DML,
sections of single tree in
TML can belong to different databases.
And also as in DDL and DML,
it's possible to specify location of section by prefix,
which is before name of section through colon.
Prefix can be
- nickname of concrete database
db1:tablename1.db2:tablename2.db3:tablename3.db4:tablename4
db1:tablename1.db2:*
- predicate
- "all:" is all databases
- "default:" is database, in which user
"is"
all:tablename1.db1:tablename2.all:tablename3.db2:tablename4
all:tablename1.all:*
default:tablename1.db1:tablename2.default:tablename3.db2:tablename4
default:tablename1.default:*
- marker - word, meaning all databases consecutively
(any two markers never simultaneously mean the same database).
Sign "%" is put before marker.
%db1:tablename1.%db2:tablename2.%db3:tablename3.%db4:tablename4
%db1:tablename1.%db2:*
Dmitry Turin
Сайт управляется системой
uCoz