Difference between revisions of "SQL"
From Organic Design wiki
(add OD interwiki to WikiFS) |
m |
||
| Line 11: | Line 11: | ||
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+interwiki; IW] | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+interwiki; IW] | ||
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=UPDATE+interwiki+SET+iw_url='http://www.organicdesign.co.nz/$1'+WHERE+iw_prefix='OD'; IW-Update] | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=UPDATE+interwiki+SET+iw_url='http://www.organicdesign.co.nz/$1'+WHERE+iw_prefix='OD'; IW-Update] | ||
| − | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=INSERT+INTO+wikifs_interwiki+(iw_prefix,iw_url,iw_local)+VALUES('OD','http://www.organicdesign.co.nz/$1',0); IW-Insert] | + | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties:SQL&xpath:/properties/SQL:query=INSERT+INTO+wikifs_interwiki+(iw_prefix,iw_url,iw_local)+VALUES('OD','http://www.organicdesign.co.nz/$1',0); IW-Insert] |
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+recentchanges+ORDER+BY+rc_timestamp+DESC+LIMIT+100; RC] | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+recentchanges+ORDER+BY+rc_timestamp+DESC+LIMIT+100; RC] | ||
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+user_rights; UR] | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+user_rights; UR] | ||
