Assuming the user has extracted ports.tar.gz from /usr, to install MySQL from ports:cd /usr/ports/da Read the rest of this entry »
Free Mysql Tutorials
OpenBSD as a Database Server
An Introduction to PEAR
The PEAR project was started by Stig S. Bakken to create a tool similar to that of Perl’s CPAN archi Read the rest of this entry »
INSERTing Data
In the last two columns we’ve focused on sorting and filtering data that is already stored in a data Read the rest of this entry »
The “Key” to Good SQL
For the next few columns, I’m going to back up and introduce you to database design — specifically Read the rest of this entry »
To refresh everyone’s memory, we’ve started talking about SQL JOIN statements over the past few colu Read the rest of this entry »
SQL Subqueries
Subqueries are extremely useful, particularly for web-based database applications where you need to Read the rest of this entry »
Ten MySQL Best Practices
1. Set a password for the “root” user and then rename the user.The first thing you should do with a Read the rest of this entry »
This scenario occurs often in applications that need to rank and paginate data by some criterion suc Read the rest of this entry »
Despite excessive planning, though, an application is never perfect whenit’s first released. Invaria Read the rest of this entry »
That’s fine in some situations but in larger companies, especially thosewith a formal “Corporate IT” Read the rest of this entry »