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:
- Mac OS/X
- IBM AIX
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 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
Install MySQL on Linux
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:
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
We use CREATE DATABASE statement to create a new database.
We use CREATE TABLE statement to create a new database table.
The INSERT statement is the most common to populate the database table with data.
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
MySQL Sub query
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 Import 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.
For more information on MySQL, visit the official website: