Database Related Tutorials - LearnPHP.org
We're continuing our exploration of the WHERE clause by digging a little deeper into its capabilities to see what it can really do.
April 10,
2008
Today Views:
3 Total Views:
82
John Paul Ashenfelter continues his SQL tutorial with one of the most useful but most frustrating areas of SQL: built-in functions.
April 9,
2008
Today Views:
1 Total Views:
94
This week, John Paul Ashenfelter revisits the ORDER BY clause to help you control the display of your MySQL data.
April 8,
2008
Today Views:
1 Total Views:
76
As with any programming language, there are a few terms unique to that language.
April 7,
2008
Today Views:
1 Total Views:
91
John Paul Ashenfelter looks at a specific class of SQL functions that operate on entire columns of data instead of discrete values -- the aggregate functions.
April 4,
2008
Today Views:
1 Total Views:
21
Noel Davis shows us buffer overflows in MySQL, analog, vixie cron, and Kerberos IV; problems with kicq, licq, and kaim; root exploits in NetBSD i386 kernels; and insecure coding with PHP and MySQL.
April 4,
2008
Today Views:
1 Total Views:
107
The GROUP BY clause is the next step after mastering ORDER BY. John Paul Ashenfelter shows you how to combine database records into a single record to calculate an aggregate function.
April 3,
2008
Today Views:
2 Total Views:
95
MySQL is currently the most popular open source database server in existence. On top of that, it is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications.
April 2,
2008
Today Views:
2 Total Views:
133
John Paul Ashenfelter looks at how keys are used to construct relationships between tables in a relational database.
April 2,
2008
Today Views:
1 Total Views:
85
The easiest way to experiment with MySQL and PHP is to purchase some space on a shared web host.
April 1,
2008
Today Views:
1 Total Views:
77
