MySQL Tutorial

What is MySQL

MySQL is an open-source relational database management system (RDBMS) which is widely used, especially as an online database for managing website data. Currently, MySQL is the second mostly used RDBMS worldwide. MySQL can be deployed at all major operating systems like Linux, Windows, Solaris, OS X etc.

History of MySQL

MySQL was previously owned by a Swedish company MySQL AB. The Database was named after the daughter of co-founder Michael Widenius, My. Now MySQL is owned by Oracle Corporation.

MySQL was previously criticized for not having the features as provided by other powerful database management systems. However, with the passage of time it kept on improving and today it’s the second most popular RDBMS.

Usability of MySQL

MySQL database is used in several high-end websites as well as popular platforms. For example, the WordPress, one of the leading blogging platform also uses MySQL. Besides, the Joomla, TYPO3, phpBB, MyBB, Drupal etc. also uses MySQL as the database. Highly popular sites like Google, Facebook, Twitter, Youtube also uses MySQL in some way.

As such MySQL is a relational database system, it follows SQL standards to fulfill its operations. So, before we continue with the MySQL Tutorials and its commands, a little about SQL.

What is SQL

SQL stands for Structured Query Language, is a computer language designed to retrieve and manage data in the relational databases. SQL is ANSI standard which stands for American National Standards Institute.

Purpose of MySQL tutorial

The tutorial explains standard MySQL commands/statements in their respective chapters. The commands of MySQL can be categorized into the following:

Data Definition language that involves operations like Creating, Alter and Drop in MySQL database.

Data Manipulation Language involves Insert, Update and Delete statements.

The MySQL tutorial is for beginners who are just started learning what database and MySQL is. Also, it covers advanced topics for the advanced learners.

Tutorial examples

The MySQL tutorials contain examples that you can run on your local system as well if you have installed MySQL database. To make it easily understandable, you can click on a link just above or below each example to see the query and its output in the graphical format.

Download and install MySQL

You can download latest or old release of MySQL database from its official website, as given below:

http://www.mysql.com/downloads/

To learn MySQL, you should install MySQL Community Edition.

Downloading and installing MySQL as part of stack package

You can also download and install MySQL as part of the stack package for this tutorial. For example, downloading and installing XAMPP (https://www.apachefriends.org/index.html), particularly, if you intend to learn web development using MySQL.

The downloaded package includes Apache admin, MySQL, PHP, and Perl.

Table of content of MySQL Tutorial

Chapters in this tutorial:

  1. MySQL Tutorial
  2. Create database
  3. Create table
  4. MySQL Insert
  5. MySQL Update
  6. MySQL Delete
  7. MySQL Select
  8. MySQL Alter
  9. MySQL Like
  10. MySQL Group by
  11. MySQL Joins
    1. The left join