Using the SQL bot

From #mysql Freenode

If you are in the #mysql channel on Freenode, and the bot (named the_wench) is present, you can use it to search the manual and other assorted functions. By prefixing a command with ! you can make use of its various capabilities.

Table of contents

1 The MySQL Manual 2 The PHP Manual 3 The Knowledge Base 4 Miscellaneous Functions 5 Help in Other Languages

The MySQL Manual

The Current MySQL manual is 5.0.

• !man - Search the current MySQL manual.
  • usage: "!man [function]"
  • ex: "!man insert syntax"
    • typical output: <the_wench> see http://dev.mysql.com/doc/refman/5.0/en/insert.html

• !m - Search the current MySQL manual and address the result to someone.
  • usage: "!m [nick] [function]"
  • ex: "!m chadmaynard string functions"
    • typical output: <the_wench> chadmaynard see http://dev.mysql.com/doc/refman/5.0/en/string-functions.html

• !man41 - Search the MySQL 3.23, 4.0 and 4.1 manual.
  • usage: "!man41 [function]"
  • ex: "!man41 alter table syntax"
    • typical output: <the_wench> see http://dev.mysql.com/doc/refman/4.1/en/alter-table.html

• !m41 - Search the MySQL 3.23, 4.0 and 4.1 manual and address the result to someone.
  • usage: "!m41 [nick] [function]"
  • ex: "!m41 archivist gone away"
    • typical output: <the_wench> archivist see http://dev.mysql.com/doc/refman/4.1/en/gone-away.html

• !man50 - Search the MySQL 5.0 manual (Currently equivalent to !man).
  • usage: "!man50 [function]"
  • ex: "!man50 explain"
    • typical output: <the_wench> see http://dev.mysql.com/doc/refman/5.0/en/explain.html

• !m50 - Search the MySQL 5.0 manual and address the result to someone (Currently equivalent to !m).
  • usage: "!m50 [nick] [function]"
  • ex: "!m50 seekwill select into"
    • typical output: seekwill see http://dev.mysql.com/doc/refman/5.0/en/select-into-statement.html

• !man51 - Search the MySQL 5.1 manual.
  • usage: "!man51 [function]"
  • ex: "!man51 engines"
    • typical output: <the_wench> see http://dev.mysql.com/doc/refman/5.1/en/engines-table.html

• !m51 - Search the MySQL 5.1 manual and address the result to someone.
  • usage: "!m51 [nick] [function]"
  • ex: "!m51 snoyes subquery"
    • typical output: <the_wench> snoyes see http://dev.mysql.com/doc/refman/5.1/en/subqueries.html

The PHP Manual

• !php - Search the PHP manual
  • usage: "!php [function]"
  • ex: "!php mysql_fetch_assoc"
    • typical output: <the_wench> array mysql_fetch_assoc ( resource result ) Fetch a result row as an associative array http://php.net/mysql_fetch_assoc

The Knowledge Base

• The bot is automatically triggered by certain words or phrases, called factoids, and will reply to the channel.
  • ex: "normalization"
    • typical output: <the_wench> http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html and http://datamodel.org/NormalizationRules.html and http://mysqldump.azundris.com/archives/20-Nermalisation.html and some here http://www.keithjbrown.co.uk/vworks/mysql/

• !tell - Searches the knowledge base and directs the reply to an individual.
  • usage: "!tell [nick] about [factoid]"
  • ex: "!tell Xgc about gui"
    • typical output: <the_wench> Xgc GUI tools can be found at http://dev.mysql.com/downloads/gui-tools/5.0.html phpMyAdmin at http://www.phpmyadmin.net/ and even navicat

Miscellaneous Functions

• !perror - Print an explanation of an error code.
  • usage: "!perror [errno]
  • ex: "!perror 145"
    • typical output: <the_wench> MySQL error code 145: Table was marked as crashed and should be repaired

Help in Other Languages

• Freenode's #mysql is a primarily English-speaking channel, and although we are always willing to try to help, sometimes we are simply unable to communicate with people who do not speak English. We do, however, offer a limited amount of foreign language support within the_wench. For more information, simply type "help" (en), "aide" (fr), "hilfe" (de), or "ayuda" (es) within #mysql.

• Please note that there are other mysql support channels on freenode dedicated to languages other than English.
  • #mysql.de

CM