Online DDL (Data Definition Language) when applying the InnoDB Storage Engine.

Stored procedures with a procedural language that adheres to PSM/SQL closely.

A broad ANSI SQL 99 subset as well as extensions.

Some major features of MySQL are as follows: MySQL Enterprise Server is characterized by a proprietary extension series which install as the server plugins, but shares the numbering system of the version and is created from a similar codebase. MySQL comes in two different editions: the proprietary Enterprise Server and the open-source MySQL Community Server. Also, MySQL is used by several famous websites including YouTube, Twitter, MediaWiki, Flicker, and Facebook.

MySQL is used by several database-driven web applications such as WordPress, phpBB, Joomla, and drupal.

MySQL is an element of the LAMP web application software stack which stands for Linux, Apache, MySQL, Python/PHP/Perl.

MySQL contains stand-alone clients that permit users for interacting with the MySQL database with SQL directly, but MySQL is used with several programs for implementing applications that require the capability of the relational database.

When Oracle inherited Sun, Widenius divided the open-source project of MySQL for creating MariaDB in 2010.

It was sponsored and owned by MySQL AB (a Swedish company) which was purchased by Sun Microsystems ( Oracle Corporation).

MySQL is open-source and free software under the GNU General Public License terms and it is also present under a range of proprietary licenses.

It permits network access and offers backup creation and testing of database integrity. In addition to SQL and relational databases and RDMS such as MySQL operates with an operating system for implementing a relational database in the storage system of the computer.

Structured Query Language is a language that programmers use to establish, change, and extract data through the relational database and control access of the user to the database.

The relational database manages data into multiple data tables in which the types of data might be related to each other the relations aid structure of the data. Its title is a set of 'My' the title of the daughter of the co-founder Michael Widenius, and 'SQL', stands for Structured Query Language. MySQL is an open-source RDMS ( Relational Database Management System). Next → ← prev Check MySQL Version Ubuntu Introduction to MySQL

Install navicat on ubuntu