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
Install MySQL on Windows
Windows 11
Download Install MySQL On Windows 11
Install MySQL on Linux
MySQL Architecture
MySQL Components
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, and views. Insert and retrieve data from tables.
MySQL Database Structure
MySQL Data types
MySQL Storage Engines
Create Database
We use CREATE DATABASE statement to create a new database.
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 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.
- SELECT Statement
- SELECT WHERE Clause
- SELECT DISTINCT Clause
- SELECT LIMIT Statement
- SELECT ORDER BY Clause
Retrieve Information From MySQL Table/
GROUP BY
Update Statement
REPLACE Statement
DELETE Statement
Create View
DROP Table
DROP Database
MySQL Operators
MySQL Functions
MySQL Sub query
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.
INNER JOIN
OUTER JOIN
MySQL Export
MySQL Import Utility
Import Data with MySQLImport Utility
MySQL Workbench
Related Links
For more information on MySQL, visit the official website: