Main Page
From #mysql Freenode
Freenode's #mysql Wiki
Welcome to the Wiki for the Freenode #mysql IRC channel.
This is a fresh new start for our wiki, using the very nice MediaWiki software (as used by WikiPedia (http://www.wikipedia.org)). There will be plenty of actual content to come, however in the meantime feel free to create it yourself. It is my intention that this wiki becomes second only to the MySQL Reference Manual (http://www.mysql.com/doc) itself for useful content. We need tutorials, examples (SQL, PHP, C, Python, etc.), advice and perhaps even sample schemas.
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 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 then put a request on either the talk page or here and someone will probably lift the protection a lot quicker.
Wikki Account Creation
New account creation was disabled due to the spamming problem. For that reason, if you want to edit #mysql then please send an email to hashmysqla monkey googlemail.com, replacing monkey by '@'. Include you desired user name and we will send you an email with the new password, hopefully, quickly. Alternatively if you hang out on #mysql you may well be able to ask one of the sysops there to do it.
#mysql
- 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.
- Recently there was an issue with a user from the perl Mongers network. A quick google for 'p3m irc' yielded nothing useful on the first page. Since there was no way to ensure that the user wouldn't return with a different hostmask the "@p3m/member/*" was banned. It appears this this was too broad a block. We were contacted by a second user shortly after the ban was put in place, Rather than seeking to understand why ban was put in place they were belligerent and condescending. They did however provide a URL to the p3m website. After a quick review of the site ( p3m.org ) provided no indication as to how hostmasks were assigned, nor a method of noting a problem user. Later a third p3m user, this one claiming to represent the network contacted us about the ban. As similar to the first two users this individual was combative, disrespectful and exhibited a complete indiference for the channel policies. The result of which is a "non-speaking" ban for the entire 'p3m/member' network has been put in place. This ban will remain in place until such time as the offending members provide an apology and demonstrate respect for others. If you are a "p3m/member" and this affects you, we apologize, but you are being judged by the company you keep.
- Channel Policies
- ChannelRegulars
- Using the SQL bot
- Frequently Asked Questions
- Search the MySQL Manual (http://hashmysql.org:4180/)
Official MySQL Links
- MySQL User Conference 2008 (http://en.oreilly.com/mysql2008/public/content/home)
- MySQL Technical Support (http://www.mysql.com/support)
- MySQL Training and Certification (http://www.mysql.com/training)
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
Installing MySQL
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
- PHP Example #2
- C API Tutorial
- Python Tutorial
- Perl Tutorial
- Java Tutorial
- C# Tutorial
- Ruby Tutorial
What not to do
Hardware
User Contributed Scripts
- MySQL Backup
- Pretty Time - A function to display time neatly
- A Very Bad Idea(tm) - Search every field in every table for a given string

