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 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:

  • 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

https://www.testingdocs.com/mysql-database-editions/

Install MySQL on Windows

Windows 10

https://www.testingdocs.com/mysql-community-edition-download/

Windows 11

https://www.testingdocs.com/download-install-mysql-on-windows-11/

Install MySQL on Linux

https://www.testingdocs.com/install-mysql-server-on-linux/

MySQL Architecture

https://www.testingdocs.com/mysql-architecture/

 

MySQL Architecture

MySQL Components

https://www.testingdocs.com/different-mysql-components/

Start MySQL Server

https://www.testingdocs.com/start-mysql-server-on-windows-11/

Start MySQL Client

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

https://www.testingdocs.com/start-mysql-client-on-windows-11/

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

https://www.testingdocs.com/mysql-database-structure/

MySQL Data types

MySQL Data Types

Numeric Data Types

String Data Types

Temporal Data Types

MySQL Storage Engines

https://www.testingdocs.com/mysql-storage-engines/

Create Database

We use CREATE DATABASE statement to create a new database.

https://www.testingdocs.com/create-a-new-database-in-mysql-server/

Create Table

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

https://www.testingdocs.com/create-a-table-in-mysql-database/

INSERT Statement

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

INSERT Statement

https://www.testingdocs.com/insert-data-into-a-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.

SELECT Statement

SELECT WHERE Clause

SELECT DISTINCT Clause

SELECT LIMIT Statement

SELECT ORDER BY Clause

https://www.testingdocs.com/retrieve-information-from-a-mysql-table/

GROUP BY

https://www.testingdocs.com/mysql-group-by-clause/

Update Statement

https://www.testingdocs.com/mysql-update-statement/

REPLACE Statement

https://www.testingdocs.com/mysql-replace-statement/

DELETE Statement

https://www.testingdocs.com/mysql-delete-statement/

Create View

https://www.testingdocs.com/mysql-create-view-statement/

DROP Table

https://www.testingdocs.com/mysql-drop-table-statement/

DROP Database

https://www.testingdocs.com/drop-database-mysql-statement/

MySQL Operators

https://www.testingdocs.com/mysql-arithmetic-operators/

https://www.testingdocs.com/mysql-comparison-operators/

https://www.testingdocs.com/mysql-logical-operators/

MySQL Functions

https://www.testingdocs.com/mysql-functions/

https://www.testingdocs.com/mysql-aggregate-functions/

MySQL Sub query

https://www.testingdocs.com/mysql-subquery/

MySQL Export

https://www.testingdocs.com/mysql-mysqldump-export/

MySQL Import Utility

https://www.testingdocs.com/import-data-with-mysqlimport-utility/

MySQL Workbench

https://www.testingdocs.com/mysql-workbench-overview/

 

MySQL Workbench UI

Related Links

For more information on MySQL, visit the official website:

https://www.mysql.com/