Using the SQL bot
From Hashmysql
If you are in the #mysql channel on Freenode, and the bot 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.
<nick> can either be anyone you want the bot to tell it, or use "me" for yourself, or use "us".
You can also browse all known bot factoids. (See !t command below)
-
!m <nick> <section>- Tells <nick> the URL to the section in the MySQL manual on dev.mysql.com. I.e.
!m johndoe selectWill also search for functions and settings, but with a lower priority than sections.
- Tells <nick> the URL to the section in the MySQL manual on dev.mysql.com. I.e.
-
!man section- Return the URL to the section in the MySQL manual on dev.mysql.com. I.e.
!man selectWill also search for functions and settings, but with a lower priority than sections.
- Return the URL to the section in the MySQL manual on dev.mysql.com. I.e.
-
!n <nick> <anchor>- Tells <nick> the URL to the page anchor in the MySQL manual where the mysql <anchor> is described. This is useful to point directly to a function or setting variable. I.e.
!n johndoe date_format,!n johndoe innodb_log_file_size.
- Tells <nick> the URL to the page anchor in the MySQL manual where the mysql <anchor> is described. This is useful to point directly to a function or setting variable. I.e.
-
!noo <anchor>- Return the URL to the page anchor in the MySQL manual where the mysql <anchor> is described. This is useful to point directly to a function or setting variable. I.e.
!noo date_format,!noo innodb_log_file_size.
- Return the URL to the page anchor in the MySQL manual where the mysql <anchor> is described. This is useful to point directly to a function or setting variable. I.e.
-
!t(ell) <nick> [about] <factoid>- Looks up the <factoid> in an internal database and returns it to the channel, prepended with the given nick. "about" may be left out. I.e.
!t me about reset root.
- Looks up the <factoid> in an internal database and returns it to the channel, prepended with the given nick. "about" may be left out. I.e.
-
!g[oogle] <nick> <search>- Returns a URL to a Google result based on <search> string. Use it to diplomatic tell a user that Google might be the best choice for his question.
-
!l <nick> <search>- Returns a URL to lmgtfy.com containing <search> string. Use it to not-so-diplomatic tell a user that his questions can be easily answered by using Google.
-
!perror- Returns the corresponding error message to the given <errorid>, either system error or mysql error or both. Example:
!perror 13Note: that command comes with mysql, so you can run "perror 13" on your shell as well.
- Returns the corresponding error message to the given <errorid>, either system error or mysql error or both. Example:
-
!learn f[actoid]|t[rigger]|a[lias] <key> :: <value>- Teach the bot a new factoid, trigger or alias - but don't add garbage! You need to be identified with NickServ for !learn. An alias can only be created to an existing factoid. To teach a new factoid <key>, that <key> must not exist. Triggers are special factoids the bot will return even without !tell. Note the delimiter :: between key and value.
