Difference between revisions of "SQL"

From Organic Design wiki
(common commands)
(add some current info and topics)
Line 28: Line 28:
 
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+cur_title+FROM+cur+WHERE+cur_title+REGEXP('^Sys:'); Sys:User articles]
 
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+cur_title+FROM+cur+WHERE+cur_title+REGEXP('^Sys:'); Sys:User articles]
 
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+cur_title+FROM+cur+WHERE+cur_title+REGEXP('^Sys:')+AND+cur_text+REGEXP('admin'); xwAdmins]
 
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+cur_title+FROM+cur+WHERE+cur_title+REGEXP('^Sys:')+AND+cur_text+REGEXP('admin'); xwAdmins]
 +
 +
== Documentation ==
 +
*[http://dev.mysql.com/doc/index.html Official MySQL Documentation]
 +
*[http://www.w3schools.com/sql/sql_join.asp W3C SQL Tutorial]
 +
*[http://www.sql-tutorial.com/ SQL-Tutorial.com]
 +
 +
== MySQL News & Information ==
 +
*[http://dev.mysql.com/doc/falcon/en/falcon-overview.html Falcon Overview] ''- the new MySQL 6 Falcon storage engine''
 +
 +
== Towards SQL for P2P environments ==
 +
*[http://pier.cs.berkeley.edu The PIER Project]
 +
*[[w:Prefix Hash Tree|Prefix Hash Trees]]
 +
*[http://www.cs.huji.ac.il/~ittaia/papers/AAY-OPODIS05.pdf Skip B-Trees]

Revision as of 05:46, 5 June 2007

{{#security:*|admin}}

Common MySQL queries

Insert into interwiki
<sql>INSERT INTO interwiki (iw_prefix,iw_url,iw_local) VALUES('example','http://www.example.org/$1',0);</sql>
Backup and compress DB & FS
<bash>mysqldump awg -u db --password='password' | 7za a -si backupfile.sql.7z</bash>
<bash>tar cf - directory | 7za a -si backupfile.t7z</bash>

Some SQL queries executable by admin (need fixing to work in new MW1.9.3 environment)

Documentation

MySQL News & Information

Towards SQL for P2P environments

Retrieved from "https://organicdesign.nz/wiki/index.php?title=SQL&oldid=71107"