Free Mysql Tutorials

Free Mysql Tutorials

Feb
11

OpenBSD as a Database Server

Posted by admin

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 »

Feb
10

An Introduction to PEAR

Posted by admin

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 »

Feb
10

INSERTing Data

Posted by admin

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 »

Feb
10

The “Key” to Good SQL

Posted by admin

For the next few columns, I’m going to back up and introduce you to database design — specifically Read the rest of this entry »

Feb
10

The Outer Limits of SQL JOINs

Posted by admin

To refresh everyone’s memory, we’ve started talking about SQL JOIN statements over the past few colu Read the rest of this entry »

Feb
10

SQL Subqueries

Posted by admin

Subqueries are extremely useful, particularly for web-based database applications where you need to Read the rest of this entry »

Feb
10

Ten MySQL Best Practices

Posted by admin

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 »

Feb
10

How to Optimize Rank Data in MySQL

Posted by admin

This scenario occurs often in applications that need to rank and paginate data by some criterion suc Read the rest of this entry »

Feb
10

Upgrading a MySQL Application

Posted by admin

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 »