MySQL Tutorials - Herong's Tutorial Examples
∟MySQL Introduction and Installation
Tutorial examples and notes are provided on MySQL installation on Windows systems. Topics include main features of MySQL; downloading and installing MySQL; starting and stopping MySQL server; introduction of command line client tool, shell, workbench.
What Is MySQL?
Downloading and Installing MySQL
Issues during MySQL Installation
Starting and Stopping MySQL Server
Un-Installing MySQL
MySQL Command Line Client Tool
What Is MySQL Shell
What Is MySQL Workbench
Using MySQL Noinstall Package
MySQL Data Directory Initialization
Creating MySQL Windows Service
%mysql% Variable for MySQL Server Path
Conclusions:
- MySQL is an open source Relational DataBase Management System (RDBMS).
- You can install MySQL 8.0 with MySQL Installer on Windows.
It includes MySQL Server, MySQL tools, MySQL Shell, MySQL Workbench, etc.
- MySQL Installer creates a new Windows service "MySQL80" to
start and stop the MySQL Server.
- MySQL command line tool "mysql" allows you to access and manage MySQL Server
with commands.
- MySQL Shell allows you to access and manage MySQL Server with
JavaScript or Python scripts.
- MySQL Workbench allows to access and manage MySQL Server with
a Graphical User Interface (GUI).
- You can also install MySQL Server using a noinstall ZIP package,
which requires you to initialize the data directory and create Windows service
manually.
Table of Contents
About This Book
Introduction of SQL
►MySQL Introduction and Installation
Introduction of MySQL Programs
PHP Programs and MySQL Server
Perl Programs and MySQL Servers
Java Programs and MySQL Servers
Datatypes and Data Literals
Operations and Expressions
Character Strings and Bit Strings
Commonly Used Functions
Table Column Types for Different Types of Values
Using DDL to Create Tables and Indexes
Using DML to Insert, Update and Delete Records
Using SELECT to Query Database
Transaction Management and Isolation Levels
Locks Used in MySQL
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
Using Administration Statements
MySQL Server on macOS
Installing MySQL Server on Linux
Connection, Performance and Second Instance on Linux
Outdated Tutorials
References
Full Version in PDF/EPUB