 |
Mysql Tutorials
MySQL tutorials and articles where you should be able to find the right MySQL tutorial to suit your need. 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.
 |
Using MySQL Functions for More Efficient Web Applications Aug 11th by Katharine Osborne
There is much debate as to whether or not data calculations should be done in the web app or in the database. There are good arguments on both sides. Depending on what is being calculated, executing calculations in some web programming languages tends to be faster than doing the same thing in the database. However, keeping... |
 |
Installing MySQL on Windows Feb 28th 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... |
|
Implementing High Availability in MySQL Jan 14th 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. |
|
Stored Procedures are EVIL Sep 7th 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... |
|
MySQL Database Handling in PHP Aug 31st 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. |
|
A Flexible Method of Storing Control Data Aug 29th 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. |
|
Exploring MySQL CURDATE and NOW. The Same But Different. Aug 17th 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. |
|
Creating a PostgreSQL and MySQL driver Sep 20th 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? |
|
Writing Syslog Messages to MySQL Aug 4th 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. |
|
SQL In Simple English - Part I Jun 11th 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... |
|
SQL In Simple English - Part II Jun 11th 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. |
