Difference between revisions of "SQL"

From Organic Design wiki
(add w prefix for wikipedia)
(use {{SERVER}} su it can sync to other xmlwikis properly)
Line 1: Line 1:
 
;Some SQL queries executable by admin
 
;Some SQL queries executable by admin
−
*[http://organicdesign.co.nz/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SHOW+TABLES; Tables]
+
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SHOW+TABLES; Tables]
−
*[http://organicdesign.co.nz/wiki/index.php?title=SQL&xpath:/properties/SQL:query=DROP+TABLE+xwHistory; Drop]
+
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=DROP+TABLE+xwHistory; Drop]
−
*[http://organicdesign.co.nz/index.php?title=SQL&xpath:/properties/SQL:query=DESCRIBE+xwHistory; Info]
+
*[{{SERVER}}/index.php?title=SQL&xpath:/properties/SQL:query=DESCRIBE+xwHistory; Info]
−
*[http://organicdesign.co.nz/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:query=SELECT+*+FROM+user+ORDER+BY+user_id; Select User]
−
*[http://organicdesign.co.nz/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+categorylinks; CL]
+
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+categorylinks; CL]
−
*[http://organicdesign.co.nz/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:query=SELECT+*+FROM+cur+WHERE+cur_namespace=14; CUR]
−
*[http://organicdesign.co.nz/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:query=DELETE+FROM+user+WHERE+user_id=142; Delete]
−
*[http://organicdesign.co.nz/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:query=UPDATE+cur+SET+cur_title='Article_title'+WHERE+cur_id=3047; Update]
−
*[http://organicdesign.co.nz/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]
−
*[http://organicdesign.co.nz/wiki/index.php?title=SQL&xpath:/properties/SQL:query=INSERT+INTO+interwiki+(iw_prefix,iw_url,iw_local)+VALUES('w','http://en.wikipedia.org/wiki/$1',0); IW-Insert]
+
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=INSERT+INTO+interwiki+(iw_prefix,iw_url,iw_local)+VALUES('w','http://en.wikipedia.org/wiki/$1',0); IW-Insert]
−
*[http://organicdesign.co.nz/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]

Revision as of 01:50, 31 October 2006

Some SQL queries executable by admin
Retrieved from "https://organicdesign.nz/wiki/index.php?title=SQL&oldid=37458"