MySQL Tutorials

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 Microsystems acquired MySQL in 2008. Oracle Corporation acquired Sun Microsystems 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:

  • Windows
  • Linux
  • Mac OS/X
  • IBM AIX
  • Solaris

In this tutorial, you will learn the basics of MySQL and how to access a MySQL database.

MySQL Editions

MySQL Database Editions

Install MySQL on Windows

Windows 11

Download Install MySQL On Windows 11

Install MySQL on Linux

Install MySQL Server On Linux

MySQL Architecture

MySQL Architecture

 

MySQL Architecture

MySQL Components

Different MySQL Components

Start MySQL Server

Start MySQL Server On Windows

Start MySQL Client

Start MySQL command-line client and connect to a MySQL Server.

Start MySQL Client On Windows

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, and views. Insert and retrieve data from tables.

MySQL Database Structure

MySQL Database Structure

MySQL Data types

MySQL Storage Engines

MySQL Storage Engines

Create Database

We use CREATE DATABASE statement to create a new database.

Create New Database In MySQL

Create Table

We use CREATE TABLE statement to create a new database table.

Create Table In MySQL Database

INSERT Statement

The INSERT statement is the most common to populate the database table with data.

INSERT Statement

Insert Data Into MySQL Database Table

SELECT Statement

The SELECT statement is used to retrieve data from the MySQL database. The SELECT statement is DML (Data Manipulation Language) statement.

Retrieve Information From MySQL Table/

GROUP BY

MySQL GROUP BY Clause

Update Statement

MySQL Update Statement

REPLACE Statement

MySQL Replace Statement

DELETE Statement

MySQL Delete Statement

Create View

MySQL Create View Statement

DROP Table

MySQL Drop Table Statement

DROP Database

Drop Database MySQL Statement

MySQL Operators

MySQL Functions

MySQL Functions

MySQL Aggregate Functions

MySQL Sub query

MySQL Subquery

MySQL Joins

The SELECT query retrieves data from a single table at a time. A MySQL database schema can contain multiple tables. We have to join tables to obtain related information from multiple tables. Joining tables is combining multiple tables when it is necessary to obtain data that is stored in multiple tables. Tables can be joined together using a SELECT statement which retrieves data from more than one table at a time.

MySQL Joins

MySQL Comma Joins

INNER JOIN

MySQL Inner Join

OUTER JOIN

MySQL Outer Join

MySQL Export

MySQLDump Export

MySQL Import Utility

Import Data with MySQLImport Utility

MySQL Workbench

MySQL Workbench Overview

 

MySQL Workbench UI

Related Links

For more information on MySQL, visit the official website:

https://www.mysql.com/