jsÕýÔò½âÎöSQL×Ö·û´® - Web ¿ª·¢ / JavaScript

ÕýÔò±í´ïʽ ½âÎöSQL Óï·¨×Ö·û´®

×Ö·û´®ÑùÀý

JScript code:


select * from mtab

select * from mtab where id=10

select * (select * from mmtab where id=10) where id=10
//È¡µÃ (select * from mmtab where id=10)

select * (select * from mmtab where (id=10 and zz=5)) where id=10
//È¡µÃ (select * from mmtab where (id=10 and zz=5))

select * (select * from mmtab where (id=10 and zz=5)) where (id=10 zz=5)
//È¡µÃ (select * from mmtab where (id=10 and zz=5))

select * (select * from mmtab where (id=10 and zz=5)) where (id=10 zz=5) order by id desc
//È¡µÃ (select * from mmtab where (id=10 and zz=5))






ËùÓкó±ßÒ²¿ÉÄÜûÓÐwhere×Ó¾ä

ÏÈлл´ó¼ÒÁË

---

(?<=select \* )\([^)]+\)

---

ÉÏÃæûÓÐ˵Çå ÎÒµÄÒâ˼ÊÇ ÏëÒªµÚÒ»¸öÀ¨ºÅ Àï±ßµÄ¶«Î÷
Èç
JScript code:


select * (select * from mmtab where (id=10 and zz=5)) where (id=10 zz=5) order by id desc
//È¡µÃ (select * from mmtab where (id=10 and zz=5))

---

Ҫд¸öSQL Parser
¿ÉÒÔ¿´Ò»Ï TrimQuery http://code.google.com/p/trimpath/wiki/TrimQuery

---

(?<=select \* )\([^)]+[)][)]*

---

JScript code

---

Code highlighting produced by Actipro CodeHighlight