<mediawiki xmlns="http://www.mediawiki.org/xml/export-0.10/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.mediawiki.org/xml/export-0.10/ http://www.mediawiki.org/xml/export-0.10.xsd" version="0.10" xml:lang="en">
  <siteinfo>
    <sitename>Hashmysql</sitename>
    <dbname>v_hashmywiki</dbname>
    <base>https://hashmysql.net/wiki/Main_Page</base>
    <generator>MediaWiki 1.30.0</generator>
    <case>first-letter</case>
    <namespaces>
      <namespace key="-2" case="first-letter">Media</namespace>
      <namespace key="-1" case="first-letter">Special</namespace>
      <namespace key="0" case="first-letter" />
      <namespace key="1" case="first-letter">Talk</namespace>
      <namespace key="2" case="first-letter">User</namespace>
      <namespace key="3" case="first-letter">User talk</namespace>
      <namespace key="4" case="first-letter">Hashmysql</namespace>
      <namespace key="5" case="first-letter">Hashmysql talk</namespace>
      <namespace key="6" case="first-letter">File</namespace>
      <namespace key="7" case="first-letter">File talk</namespace>
      <namespace key="8" case="first-letter">MediaWiki</namespace>
      <namespace key="9" case="first-letter">MediaWiki talk</namespace>
      <namespace key="10" case="first-letter">Template</namespace>
      <namespace key="11" case="first-letter">Template talk</namespace>
      <namespace key="12" case="first-letter">Help</namespace>
      <namespace key="13" case="first-letter">Help talk</namespace>
      <namespace key="14" case="first-letter">Category</namespace>
      <namespace key="15" case="first-letter">Category talk</namespace>
    </namespaces>
  </siteinfo>
  <page>
    <title>Main Page</title>
    <ns>0</ns>
    <id>5</id>
    <revision>
      <id>3195</id>
      <parentid>3194</parentid>
      <timestamp>2021-05-19T18:30:07Z</timestamp>
      <contributor>
        <username>Vacuity</username>
        <id>1140</id>
      </contributor>
      <comment>/* Protected Pages */</comment>
      <model>wikitext</model>
      <format>text/x-wiki</format>
      <text xml:space="preserve" bytes="3298">__NOTOC__
== #mysql Wiki == 
 
Welcome to the Wiki for the #mysql IRC channel. You can find the channel on libera.chat . For more information about Libera, please see [https://libera.chat/ https://libera.chat/]. 

Do please help make this a wonderful resource for the entire MySQL community. 

===Protected Pages===
We used to have a serious problem with spam and rather a of lot pages had to be protected as a stop gap. A few of those pages may still be protected. If you want to edit a protected page, put a request on either the talk page or ask in the channel, and someone will probably lift the protection a lot quicker.

===Wiki Account Creation===
New account creation was disabled due to the spamming problem.  For that reason, if you want to edit the wiki, then please join us on #mysql and ask one of the sysops there to create one for you.

=== #mysql ===
*To talk in #mysql, you need to have your nickname registered with Libera's [https://libera.chat/guides/registration NickServ] and be identified with that account. Hint: &lt;code&gt;/msg NickServ help&lt;/code&gt;
*Channel Management: As the number of channel members has grown the need to keep thing to a dull roar has also grown. We are here to help, support and promote the MySQL Community. As such channel moderators may, at their discretion, may put in place any bans they feel best suits the needs. Usually this will be just the individual. However, if further disruption cannot be assured with a highly targeted banning then banning entire networks, ISPs and even countries.
*[[Channel Policies]] 
*[[ChannelRegulars]] 
*[[Using the SQL bot]] 
*[[FAQ | Frequently Asked Questions]] 
*The main language in #mysql is English. You can try to ask in a different language, perhaps you are lucky. Please note there are also channels in other languages, i.e. #mysql.de

=== Official MySQL Links === 
*[http://dev.mysql.com/doc/ MySQL documentation]
*[http://www.mysql.com/support MySQL Technical Support] 
*[http://www.mysql.com/training MySQL Training and Certification]

=== [[SQL Tutorials and Best Practices]] === 
*[[BINARY attribute for the weak]] 
*[[Basic SQL Statements]] 
*[[Introduction to Joins]] 
*[[More Advanced Joins]] 
*[[Basic Views]]
*[[Basic Debugging]]
*[[Normalization]] 
*[[Proper Indexing Strategy]] 
*[[Using Replication]] 
*[[ALTER TABLE - Setting MAX_ROWS]]
*[[Select rows in table A that are not in table B]]
*[[Autoincrement FAQ]]
*[[Zerofill]]
*[[Unique/Distinctive Selection]]
*[[Trees and hierarchical data in SQL]]
*[[Using Null]]

*[[Optimized MySQL 101]]

=== Installing MySQL ===
*[[CentOS]]
*[[Debian]]

=== [[MySQL Troubleshooting]] === 
*[[Which Config File Is MySQL Using?]]
*[[Using EXPLAIN]] 
*[[Tuning System Variables]] 
*[[Remote Clients Cannot Connect]]

=== [[Developing for a MySQL Database]] === 
*[[PHP Tutorial]] outputting rows from a table
*[[C API Tutorial]] 
*[[Python Tutorial]] 
*[[Perl Tutorial]] 
*[[Java Tutorial]] 
*[[C# Tutorial]]
*[[Ruby Tutorial]]

=== What not to do === 
*[[Ruining your day]]

=== Hardware ===
* [[Hardware choices for MySQL]]
* [[Opteron_HOWTO]]

=== User Contributed Scripts ===
* [[MySQL Backup]]
* [[Pretty Time|Pretty Time - A function to display time neatly]]
* [[Very Bad Idea|A Very Bad Idea(tm) - Search every field in every table for a given string]]</text>
      <sha1>lk5rlkabzn10h7qk55s56qf8orsjupt</sha1>
    </revision>
  </page>
</mediawiki>
