What Is MySQL?
This section provides a quick introduction of MySQL with a list of main features.
What Is MySQL?
MySQL is an open source Relational DataBase Management System (RDBMS) developed by MySQL AB,
http://www.mysql.com. MySQL was started with mSQL with fast low-level (ISAM) routines.
So MySQL and mSQL are having almost the same application programming interfaces and
command line interfaces.
As of 2015, MySQL is the second most widely used RDBMS in the world.
Main features of MySQL (extracted from MySQL 5.0 manual):
- Works on many different platforms.
- APIs for C, C++, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl are available.
- Fully multi-threaded using kernel threads.
- Provides transactional and non-transactional storage engines.
- Uses very fast B-tree disk tables (MyISAM) with index compression.
- Very fast joins using an optimized one-sweep multi-join.
- SQL functions are implemented using a highly optimized class library and
should be as fast as possible.
- Support for aliases on tables and columns as required by SQL-92.
- Handles large databases. We use MySQL Server with databases that contain 50 million records.
We also know of users that use MySQL Server with 60,000 tables and about 5,000,000,000 rows.
- Clients may connect to the MySQL server using TCP/IP sockets on any platform.
- The Connector/ODBC interface provides MySQL support for client programs that use ODBC (Open-DataBase-Connectivity) connections.
- The Connector/JDBC interface provides MySQL support for Java client programs that use JDBC connections.
Releases of MySQL:
MySQL 5.7 - 2015
MySQL 5.6 - 2013
MySQL 5.5 - 2010
MySQL 5.1 - 2008
MySQL 5.0 - 2005
MySQL 4.1 - 2004
MySQL 4.0 - 2002
MySQL 3.2 - 1997
MySQL 1.0 - 1995
Last update: 2015.
Table of Contents
About This Book
Introduction of SQL
►MySQL Introduction and Installation
►What Is MySQL?
Downloading and Installing MySQL
Issues during MySQL Installation
Starting and Stopping MySQL Server
Creating First Table in MySQL
Using MySQL Noinstall Package
Introduction of MySQL Programs
Perl Programs and MySQL Servers
PHP 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
PDF Printing Version