Database Related Tutorials - LearnPHP.org
Maintenance is a very common task that is necessary for keeping MySQL tables current. From time to time, you may even need to delete items from your database.
February 15,
2008
Today Views:
1 Total Views:
161
Application upgrades aren't always easier. Throw in a database backend and a schema change, and you're in for a world of hurt -- unless you've planned well. Russell Dyer explores techniques for taking the pain out of upgrading database-backed applications.
February 14,
2008
Today Views:
1 Total Views:
143
You may or may not know that MySQL databases are just files that are stored on your web server. This fact makes the whole backup and restore process extremely simple and painless once you have figured out how to do it.
February 11,
2008
Today Views:
3 Total Views:
148
Normalizing data into a database saves you time and trouble representing information, but actually displaying and reporting that information is trickier.
February 8,
2008
Today Views:
1 Total Views:
151
The most common types of aggregate functions let you find out things like the minimum, maximum and even the average of a "grouped" set of data. The trick to understanding aggregate functions is often understanding what kind of data is being grouped and analyzed.
February 7,
2008
Today Views:
1 Total Views:
159
Your database-backed application is too slow. Panic, upgrade, or rewrite? Steven Hauser suggests a more thoughtful approach: step back and consider the whole system. Then, do the simplest thing with the greatest potential payoff. Hauser explains how to make the most of tuning opportunities.
February 5,
2008
Today Views:
1 Total Views:
153
This lesson will teach you how to use the aggregate function COUNT().
February 4,
2008
Today Views:
1 Total Views:
182
his lesson will teach you how to use the aggregate function SUM().
February 1,
2008
Today Views:
3 Total Views:
191
This lesson will teach you how to use the aggregate function AVG().
January 25,
2008
Today Views:
2 Total Views:
184
using dreamweaver learn how to link to a specific category in your php database.
January 18,
2008
Today Views:
1 Total Views:
304
