Database Related Tutorials - LearnPHP.org
Learn the optimization techniques for MySQL.
February 9,
2010
Today Views:
4 Total Views:
775
The insert clause has one function; to insert data into a table. Insert populates each table column with a value. Rows are inserted one right after another into the corresponding column.
February 3,
2010
Today Views:
1 Total Views:
802
It's easy to build a small web site by hand, but what happens when non-techies need to make changes? Russell Dyer demonstrates how to design and build a just-simple-enough web site management system that can alleviate your pain.
January 28,
2010
Today Views:
2 Total Views:
718
Queries are the backbone of SQL. Query is a loose term that refers to a widely available set of SQL commands called clauses.
January 26,
2010
Today Views:
1 Total Views:
851
Entire rows can be deleted from a table using the delete clause.
January 26,
2010
Today Views:
1 Total Views:
752
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...
January 22,
2010
Today Views:
4 Total Views:
756
Here are eight tips for enhancing Web database applications by using PHP and MySQL.
January 14,
2010
Today Views:
3 Total Views:
995
Here are the simple scripts I use to upload files and a script to stream the file back to the browser.
January 13,
2010
Today Views:
4 Total Views:
3,360
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...
January 8,
2010
Today Views:
1 Total Views:
789
Distinct is used to retrieve rows of your database that have unique values for a given column.
January 7,
2010
Today Views:
5 Total Views:
1,105
