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.
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 GUI Tools
Graphical User Interface tools to interact with the MySQL database:
MySQL Workbench
phpMyAdmin
phpMyAdmin is a free database tool written in PHP, intended to handle the administration of MySQL over the Internet.
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
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: