(Paul Dubois) In this final article of our series, you will learn more ways of organizing your data to achieve better query performance.

(Keith Winston) Perl and PHP are two widely used languages for building dynamic Web sites. They make up two thirds of the “P” in the Linux, Apache, MySQL, Perl/PHP/Python (LAMP) stack. How does their performance, using mod_perl and mod_php, compare for everyday Web programming? I attempted to find o

(Ian Gilfillan) Last time we looked at the Developer Stream of the MySQL 5 certification. Now, in the last part of this series, we look at the DBA stream. Passing the DBA exam, (the title you can use once qualified is the Certified MySQL 5.0 Database Administrator (DBA)), requires more in-depth know

(Nathan Broslawsky) This PHP function pulls a single field from a single record in the database once the MySQL connection has already been established.

(Alejandro Gervasio) Are you a curious PHP developer, wanting to learn how to simulate a basic Model-View-Controller schema with PHP? Then, look no further, because you’re in the right place. Welcome to the final part of the series “Simulating the Model-View-Controller Schema in PHP.” In three tutor

(oti) I was a bit conflicted about where to put this code. I didn’t know whether to put it into the Free Tools with Source section or here. I decided on here because, well, I already have an article here, and it’s starting to feel like home.

(Chris Newman) In this lesson, you learn how to use a SELECT statement to fetch records from a MySQL database.

For those who wish to enhance or fortify the security of the MySQL installation the following technical 10 steps are a good start.

(Paul Dubois) There are a number of things you can do in general to optimize your queries and make them more efficient. This article discusses several of these.

(Jon Stephens and Peter Gulutzan) Partitioning is a way of pre-organizing table storage. You can say “some of the table’s rows will go here, some will go there, still others will go to to still other places”. Often, depending on the storage engine, the effect is to spread the table’s rows over diffe