Difference between revisions of "SQL"
From Organic Design wiki
(hide benders edits until caretaker cooled off a bit) |
m |
||
| Line 12: | Line 12: | ||
*[{{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] | *[{{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] | ||
*[{{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=UPDATE+user_rights+SET+ur_rights='sysop,bot'+WHERE+ur_user=63; makeBot] | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=UPDATE+user_rights+SET+ur_rights='sysop,bot'+WHERE+ur_user=63; makeBot] | ||
