MYSQL Tutorials 
Below is our collection of SQL tutorials and articles where you should be able to find the right SQL tutorial to suit your need. We have also included here some links to important areas of SQL development to help you with your database setup and manipulation. Also visit our Scripts section for ready to use solutions to your application needs.
Installing MySQL on Windows
By Michael J. Ross
As Web sites and Web-based applications become more important to commercial firms and other organizations, so too does the methods used for storing data online, such as customer contact information, system login details, product data, and much more. Rewritable flat files may be sufficient for extremely limited data for which security is not an issue. But for most Web sites and applications, a robust database is called for.
Thursday, 28th February 2008
Implementing High Availability in MySQL
By Alberto Arbea
MySQL provides a built-in data replication functionality for maintaining identical copies of its data to one or more backend servers, thus providing a simple High Availability mechanism. On the other hand, the Open Source community has several projects to implement failover techniques, being one of them Heartbeat.
Monday, 14th January 2008
Stored Procedures are EVIL
By Tony Marston
A lot of developers are taught to use database stored procedures, triggers and database constraints at every possible opportunity, and they cannot understand why an old dinosaur like me should choose to take an opposite view. The reason can be summed up quite simply...
Thursday, 7th September 2006
MySQL Database Handling in PHP
By John L.
Most interactive websites nowadays require data to be presented dynamically and interactively based on input from the user. For example, a customer may need to log into a retail website to check his purchasing history.
Thursday, 31st August 2006
A Flexible Method of Storing Control Data
By Tony Marston
Where an application requires certain values at runtime, and where these values may be changed at irregular intervals, it is common practice to hold these on a database record rather than having them hard-coded into any program.
Tuesday, 29th August 2006
Exploring MySQL CURDATE and NOW. The Same But Different.
By David Rolston
Sometimes I see people attempting to use VARCHARS or CHARS to store dates in their MySQL database application. This is really fighting against MySQL, which has a variety of interchangeable date types.
Thursday, 17th August 2006
Creating a PostgreSQL and MySQL driver
By Tony Marston
The software that I write is not intended for just one customer who is locked into a single RDBMS. Instead it can be used by virtually any customer using the RDBMS of their choice. How is this possible?
Tuesday, 20th September 2005
Writing Syslog Messages to MySQL
By Rainer Gerhards
In this paper, I describe how to write syslog messages to a MySQL database. Having syslog messages in a database is often handy, especially when you intend to set up a front-end for viewing them.
Thursday, 4th August 2005
SQL In Simple English - Part I
By Kiran Pai
This article explains the basics of SQL as a Q&A session. Most of the questions are the ones that most novices would like to ask. This approach is excellent and readers who are not familiar with the technology. Since this article is totally language neutral, programmers using any language and who want to do database programming will find it useful.
Saturday, 11th June 2005
SQL In Simple English - Part II
By Kiran Pai
This is the second article in this series. If you liked the first one, you will definitely like this one too. This article mainly deals with SQL Joins and SQL subqueries. Both of these are extremely useful SQL constructs and should be learnt by all beginners.
Saturday, 11th June 2005