Category Archives: SQL

SQL is a popular relational database language first standardized in 1986 by the American National Standards Institute (ANSI).

mysql join and inner join

MySQL Join and Inner Join

OK now, let’s talk about joins. A SQL join combines columns from two or more tables in a single result set. You see MySQL is a relational database, and too…

MySQL Important Configuration Options

MySQL Important Configuration Options

We want to setup the MySQL Server in such a way, that at least it doesn’t give us nasty surprises, which it would if we use it as it come…

MySQL Configuration File

MySQL Configuration File

The mysql configuration file is a special text file that is read by each of the mysql programs on launch to see whether there are any startup directives that applies…

A Brief History of MySQL

The MySQL server is a unique product in a number of ways, some of these differences are beneficial even if we don’t notice them while others can cause us problems…