Difference between revisions of "SQL"
From Organic Design wiki
(wikifs into IW) |
m |
||
| Line 1: | Line 1: | ||
;Some SQL queries executable by admin | ;Some SQL queries executable by admin | ||
| − | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SHOW+TABLES; Tables] | + | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties:SQL&xpath:/properties/SQL:query=SHOW+TABLES; Tables] |
| − | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=DROP+TABLE+xwHistory; Drop] | + | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties:SQL&xpath:/properties/SQL:query=DROP+TABLE+xwHistory; Drop] |
*[{{SERVER}}/index.php?title=SQL&xpath:/properties/SQL:query=DESCRIBE+xwHistory; Info] | *[{{SERVER}}/index.php?title=SQL&xpath:/properties/SQL:query=DESCRIBE+xwHistory; Info] | ||
| − | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+user+ORDER+BY+user_id; Select User] | + | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties:SQL&xpath:/properties/SQL:query=SELECT+*+FROM+user+ORDER+BY+user_id; Select User] |
| − | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+categorylinks; CL] | + | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties:SQL&xpath:/properties/SQL:query=SELECT+*+FROM+categorylinks; CL] |
| − | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+cur+WHERE+cur_namespace=14; CUR] | + | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties:SQL&xpath:/properties/SQL:query=SELECT+*+FROM+cur+WHERE+cur_namespace=14; CUR] |
| − | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+old+WHERE+old_namespace=14; OLD] | + | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties:SQL&xpath:/properties/SQL:query=SELECT+*+FROM+old+WHERE+old_namespace=14; OLD] |
| − | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=DELETE+FROM+user+WHERE+user_id=142; Delete] | + | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties:SQL&xpath:/properties/SQL:query=DELETE+FROM+user+WHERE+user_id=142; Delete] |
| − | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=UPDATE+cur+SET+cur_title='Article_title'+WHERE+cur_id=3047; Update] | + | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties:SQL&xpath:/properties/SQL:query=UPDATE+cur+SET+cur_title='Article_title'+WHERE+cur_id=3047; Update] |
| − | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+interwiki; IW] | + | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties: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&xpath:/properties/SQL:query=INSERT+INTO+interwiki+(iw_prefix,iw_url,iw_local)+VALUES('wikifs','http://www.wikifs.org/$1',0); IW-Insert] | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties:SQL&xpath:/properties/SQL:query=INSERT+INTO+interwiki+(iw_prefix,iw_url,iw_local)+VALUES('wikifs','http://www.wikifs.org/$1',0); IW-Insert] | ||
