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.
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 a lot on #mysql you may well be able to ask one of the sysops there to do it.
#mysql
- 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
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