Database Related Tutorials - LearnPHP.org
Noel Davis looks at a problem with Perl's safe mode; some serious vulnerabilities in MySQL; buffer overflows in wget, tcpdump, Canna, and GTetrinet; and problems in lynx, mICQ, Sun Cobalt RaQ 4 Server Appliances, xdvi, dvips, and Exim.
February 22,
2008
Today Views:
2 Total Views:
276
This lesson will teach you how to do a specialized join: left join.
February 22,
2008
Today Views:
4 Total Views:
1,186
Paul DuBois has selected sample recipes from the hundreds you'll find in his book, MySQL Cookbook. In this third and final series of excerpts showcasing these recipes, learn how to compute team standings, how to calculate the differences between...
February 20,
2008
Today Views:
1 Total Views:
326
In this lesson you will learn how to replace the existing data of a MySQL table with freshly supplied up-to-date data using the UPDATE MySQL query.
February 19,
2008
Today Views:
18 Total Views:
956
Luminaries from the open source communities of Perl, Python, PHP, MySQL, Apache, and Linux each presented their take on the current state of their technology and where it is headed.
February 18,
2008
Today Views:
1 Total Views:
251
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:
364
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:
280
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:
1 Total Views:
288
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:
307
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:
288
