MySQL Tutorials

Welcome to MySQL Tutorials on this website.

MySQL is the world’s most popular open-source database software. MySQL is a Relational Database Management System (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 Corporation.

Supported Operating Systems

MySQL is cross-platform and 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

MySQL is a key part of the LAMP stack(Linux, Apache, MySQL, PHP/Perl/Python). LAMP stack is the fast-growing open source enterprise software stack.

MySQL database with its speed, performance, reliability, and ease of use has become the preferred choice for Web/Web 2.0, SaaS, ISVs, and Telecom companies.MySQL eliminates the major problems associated with downtime, maintenance, and administration
for modern, online applications.

MySQL Editions

MySQL offers different editions to cater to the needs of different users and organizations.
The flagship MySQL offering is MySQL Enterprise, a comprehensive set of production-tested
software, premium support services, and proactive monitoring tools available in an
affordable annual subscription.

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 GUI Tools

Graphical User Interface tools to interact with the MySQL database:

MySQL GUI Tools

MySQL Workbench

MySQL Workbench UI

phpMyAdmin

phpMyAdmin is a free database tool written in PHP, intended to handle the administration of MySQL over the Internet.

phpMyAdmin Database Tool

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 Repair Tool

Tool to restore corrupt MySQL database

Many of the world’s largest and fastest-growing organizations use MySQL databases to save time and money powering their high-volume websites and critical business systems.

Official Website

For more information on MySQL, visit the official website:

https://www.mysql.com/