Difference between revisions of "SQL"
From Organic Design wiki
(EA into IW) |
(JW into IW) |
||
| Line 9: | Line 9: | ||
*[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] | *[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] | ||
*[http://organicdesign.co.nz/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=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(' | + | *[http://organicdesign.co.nz/wiki/index.php?title=SQL&xpath:/properties/SQL:query=INSERT+INTO+interwiki+(iw_prefix,iw_url,iw_local)+VALUES('JW','http://jewel.peerix.org/$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] | *[http://organicdesign.co.nz/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+recentchanges+ORDER+BY+rc_timestamp+DESC+LIMIT+100; RC] | ||
