Database Related Tutorials - LearnPHP.org
George Reese, coauthor of Managing & Using MySQL, 2nd Edition, offers a set of best practices for MySQL administrators that will help with the security, maintenance, and performance of a MySQL installation.
February 28,
2008
Today Views:
1 Total Views:
105
Paul DuBois has selected sample recipes from the hundreds you'll find in his book, MySQL Cookbook. In this second article in a three-part series showcasing these recipes, find out how to manage simultaneous AUTO_INCREMENT values, and how to use AUTO_INCREMENT values and related tables.
February 26,
2008
Today Views:
2 Total Views:
91
Thus far we have only been getting data from one table at a time. This is fine for simple takes, but in most real world MySQL usage you will often need to get data from multiple tables in a single query.
February 26,
2008
Today Views:
2 Total Views:
97
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:
1 Total Views:
99
This lesson will teach you how to do a specialized join: left join.
February 22,
2008
Today Views:
1 Total Views:
94
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:
2 Total Views:
131
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:
1 Total Views:
127
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:
102
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:
2 Total Views:
121
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:
109
