Database Related Tutorials - LearnPHP.org
A MySQL table is completely different than the normal table that you eat dinner on. In MySQL and other database systems, the goal is to store information in an orderly fashion. The table gets this done by making the table up of columns and rows.
March 18,
2008
Today Views:
1 Total Views:
174
The exploration into JOIN statements continues with a look at INNER JOIN, the most commonly used SQL join.
March 17,
2008
Today Views:
3 Total Views:
169
When data is put into a MySQL table it is referred to as inserting data. When inserting data it is important to remember the exact names and types of the table's columns.
March 17,
2008
Today Views:
1 Total Views:
185
This week, John Paul Ashenfelter looks at the "self-join," a tool that is particularly useful in certain situations, such as when you have a normalized database table that needs to be flattened.
March 14,
2008
Today Views:
1 Total Views:
176
In this tutorial I will show you how to use basic database manipulation features in PHP.
March 13,
2008
Today Views:
1 Total Views:
215
So far we have seen a couple different uses of PHP's mysql_query function and we'll be seeing more of it as nearly all MySQL in PHP is done through the MySQL Query function.
March 13,
2008
Today Views:
2 Total Views:
203
Subqueries are extremely useful in web-based database applications where you need to combine two queries and manually put them together to achieve a desired result. Subqueries allow SQL to do all of the heavy lifting!
March 12,
2008
Today Views:
1 Total Views:
185
SQL stands for Structured Query Language and is used to pull information from databases.
March 11,
2008
Today Views:
4 Total Views:
173
Because SQL is based on relational algebra, it should come as no surprise that the standard contains several set-oriented operators. In that spirit, it's time we take a look at the UNION operator.
March 11,
2008
Today Views:
1 Total Views:
162
MySQL doesn't have a Fetch Array function. mysql_fetch_array is actually a PHP function that allows you to access data stored in the result returned from a successful mysql_query.
March 10,
2008
Today Views:
1 Total Views:
221
