Abbreviated syntax for 'from' and 'where'
In cases, when fields of two tables are bound by foreign key,
and user enters identical meanings into bound fields during filling database,
possibility appears to use XPath for reduction of bulky expressions, for example
XPath |
XPath |
where a/b/c/d/@d3=k/l/m/n/@n2;
|
where a.uk=b.fk and
b.uk=c.fk and
c.uk=d.fk
and
k.uk=l.fk and
l.uk=m.fk and
m.uk=n.fk
and
d.d3=n.n2;
|
I propose to allow usage of XPath also after service words 'select' and 'from',
because request on the left in pair below looks much better, than request on the right.
select d/e/f/@f3
from a/b/c
where p/q/r/@r2=5;
|
select f3
from a/b/c/d/e/f
where ../../../p/q/r/@r2=5;
|
And also after service words 'insert, update, delete'
insert into d/e/f/tab (fld)
values (5);
|
insert into a/b/c/@c1/d/e/f (fld)
values (5);
|
insert into a/b/c/@c1/d/e/tab
values ('<tag>...</tag>');
|
update d/e/f/tab
set @fld=5;
|
update d/e/f/tab
set @fld/p/q/r/@r1=5;
|
update a/b/c/@c1/d/e/f
set @fld=5;
|
delete from a/b/c/n;
|
Dmitry Turin
Сайт управляется системой
uCoz