Developer Newsletter

MYSQL Tutorials

Below is our collection of MySQL tutorials and articles. We have also included here some links to important areas of MySQL 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
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
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
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
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
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.
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
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
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
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
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