MySQL is one of the world’s most popular open-source Relational Database Management Systems (RDBMS) and has also become very popular with the spread of PHP Scripting Language. RDBMS stores data in tables.
MySQL AB a Swedish company created MySQL. Sun Micro systems acquired MySQL in 2008. Oracle Corporation acquired Sun Micro systems in 2010. MariaDB is a fork of MySQL prior to MySQL’s acquisition by Oracle.
Supported Operating Systems
MySQL runs on many operating system platforms. This allows users flexibility and control. Popular operating systems that MySQL can run are as follows:
- Mac OS/X
- IBM AIX
In this tutorial, you will learn the basics of MySQL and how to access a MySQL database.
Install MySQL on Windows
Install MySQL on Linux
Start MySQL Server
Start MySQL Client
Start MySQL command-line client and connect to a MySQL Server.
SQL stands for Structured Query Language. MySQL is ideal for storing and accessing data in a database. SQL is used to interact with the database. We can create database objects like tables, views, etc, insert and retrieve data from tables.
MySQL Database Structure
MySQL Data types
MySQL Storage Engines
We use CREATE DATABASE statement to create a new database.
We use CREATE TABLE statement to create a new database table.
The INSERT statement is the most common to populate the database table with data.
The SELECT statement is used to retrieve data from the MySQL database. The SELECT statement is DML (Data Manipulation Language) statement.
MySQL Sub query
MySQL Import Utility
For more information on MySQL, visit the official website: