Learning MySQL Aliases

MySQL aliases are simply nicknames used to express tables, columns and functions’ names. These nicknames can be used in your queries to make them short and neat. Let’s explore this feature.

continue reading »

Kick-Starting MySQL

Kick-Starting MySQL

Today MySQL is one of the most popular open source databases as it supports millions of web applications. We will discuss the basics of MySQL like creating databases and tables and interacting with data.

continue reading »

Working With MySQL Joins

working with mysql unions

In PHP applications, Retrieving data from relational tables generally require the use of joins. MySQL joins enable developers to select data from multiple tables with a single SQL statement. Let’s explore MYSQL joins.

continue reading »