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 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 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.
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.
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/
Related Links
For more information on MySQL, visit the official website: