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 26,
2010
Today Views:
1 Total Views:
1,430
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 26,
2010
Today Views:
1 Total Views:
669
This tutorial explains the basics of setting up OpenBSD as a database server using MySQL/PostgreSQL and PHP.
February 25,
2010
Today Views:
1 Total Views:
626
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 23,
2010
Today Views:
1 Total Views:
673
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 19,
2010
Today Views:
1 Total Views:
1,189
If we wanted to select only certain entries of our table, then we would use the keyword WHERE.
February 18,
2010
Today Views:
1 Total Views:
736
In the last aboutSQL column, John Paul Ashenfelter introduced the Data Definition Language (DDL) and how to create database containers. This week, he moves on to creating tables and populating them with data.
February 18,
2010
Today Views:
1 Total Views:
778
Although there are several tools available to help users efficiently and easily create pivot tables or cross-tabulations, being able to visualize the cross-tabulations in real time is much more useful.
February 16,
2010
Today Views:
2 Total Views:
633
In a previous job when I was responsible for hiring PHP developers, I always used to ask questions about database abstraction in my interviews. It's amazing how often...
February 15,
2010
Today Views:
1 Total Views:
667
Writing data in web database applications requires different techniques than reading data. Issues of transactions and concurrency become important, and we introduce these issues and the principles of dealing with them in this tutorial...
February 9,
2010
Today Views:
1 Total Views:
790
