MySQL Tutorial

MySQL Tutorial MySQL Features MySQL Database Introduction MySQL Environmental Setup MySQL Data Types MySQL variable MySQL Advance table Query MySQL database queries MySQL Entity-Relationship Model MySQL Table Query MySQL Operators MySQL logical conditions MySQL Queries MySQL Clauses Clustered vs Non-Clustered Index MySQL Full text index MySQL Descending Index MySQL Invisible Index MySQL Composite Index MySQL Prefix index MySQL Index MySQL Create index MySQL Drop Index MySQL Show index MySQL Unique index MySQL Table MySQL Variable MySQL View MySQL Constraints MySQL Command Line Client Basic Queries MySQL Stored Procedure MySQL IF Statement MySQL Subquery MySQL Triggers

MySQL Join

MySQL Join MySQL CROSS JOIN MySQL DELETE JOIN MySQL EQUI JOIN MySQL INNER JOIN MySQL Union MySQL NATURAL JOIN MySQL RIGHT JOIN MySQL SELF JOIN MySQL UPDATE JOIN

MySQL Function

MySQL Function MySQL AVG() Function MySQL SUM() Function MySQL String() Function MySQL Advance() Function MySQL Aggregate() Function MySQL COALESCE() Function MySQL Control Flow Function MySQL COUNT() Function MySQL Date And Time Function MySQL GREATEST() Function MySQL ISNULL() Function MySQL LEAST() Function MySQL Math() Function MySQL MAX() Function MySQL MIN() Function MySQL find_in_set() function MySQL ASIN() Function MySQL CEIL() function MySQL CEILING() function MySQL TAN() Function MySQL Truncate() Function MySQL FLOOR() function MySQL LN() function MySQL LOG2() function MySQL LOG10() function MySQL MOD() function MySQL PI() function MySQL POW() function MySQL RADIANS() function MySQL RAND() function MySQL ROUND() function MySQL Character Length Function MySQL Current Date Function MySQL Date Add Function MySQL Date Format Function MySQL Datediff Function MySQL Day Function MySQL Elt Function MySQL Export Set Function MySQL Field Function MySQL Format Function MySQL From Base64 Function MySQL Hex Function MySQL Insert Function MySQL Instr Function MySQL Length Function MySQL CONCAT() function MySQL FIND_IN_SET() function MySQL LIKE() function MySQL LOAD_FILE() function MySQL LOCATE() function MySQL LOG() function MySQL MONTHNAME() function MySQL NOW() function MySQL PERIOD_ADD() function MySQL PERIOD_DIFF() function MySQL POWER() function MySQL QUARTER() function MySQL REVERSE() function MySQL RIGHT() Function MySQL RPAD() function MySQL RTRIM() function MySQL SEC_TO_TIME() function MySQL SOUNDEX() function

Questions

Which Clause is Similar to Having Clause in MySQL

Misc

MySQL Error 1046 - No Database Selected Failed to Start MySQL Service Unit MySQL Service Unit not Found Import MySQL Connector Mudule not Found Error No Module Named MySQL Joins Available in MySQL MySQL Docs MySQL Download For Windows 7 64 Bit MySQL Error Code 1064 MySQL Export MySQL History MySQL Host MySQL Import MySQL Drop All Tables MySQL Drop MySQL Error Code 1175 MySQL Events MySQL Except MYSQL Foreign Key Constraint MySQL If Exists MySQL IndexOf MySQL List All Tables json_extract in MySQL TIMESTAMPDIFF in MySQL MySQL Syntax Checker Sudo MySQL Secure Installation

MySQL History
2023-12-30 16:46:33

MySQL History

Introduction

MySQL is one relational database management system (RDBMS) that may be downloaded for free. The combination of "My," the name of co-founder Michael Wideness’s daughter, and "SQL," an acronym for Structured Query Language, gave rise to its moniker. In a relational database, information is organized into one or more data tables that may be related to other information. That aids in the data's organization.

Programmers use SQL to create, modify, and retrieve Relational databases, store data, and allow for controlled user access to that data. An RDBMS, like MySQL, does more than link relational databases and SQL; it also forms a relational database in the computer's storage system, manages user access, allows network communication, and facilitates database integrity checks and backup creation.

Overview

  • MySQL AB, a Swedish business formed in 1995, is the creator of MySQL. Sun Microsystems eventually purchased the company for around $1 billion in 2008.
  • The UNIREG project, an internal database management tool created in 1979, was the precursor to the MySQL project. The creator of UNIREG is Michael Widenius. To enable it to handle large databases, UNIREG was rebuilt in many languages after its creation.
  • mSQL and UNIREG were combined to form MySQL, which bears the moniker "My" after Michael Widenius's daughter. The two people who designed mSQL, Michael Widenius and David Hughes, worked together to link mSQL to UNIREG's B+ ISAM handler so that mSQL could offer indexing.
  • MySQL is free and open-source software as long as it abides by the Linux kernel's General Public License terms. Additionally, it is available under several proprietary licenses. The owner and sponsor of MySQL was the Swedish company MySQL AB, which was bought up by Sun Microsystems (now Oracle Corporation). After Widenius moved off the open-source MySQL project to become MariaDB, Sun was acquired by Oracle in 2010.
  • While stand-alone clients allow users to connect directly with a MySQL database using SQL, MySQL is also frequently used with other tools to construct applications requiring relational database capability. MySQL is a part of the LAMP web application software stack, an acronym for Linux, Apache, MySQL, Perl, PHP, Python, and others.
  • Many database-driven web applications use MySQL, including WordPress, Drupal, Joomla, and phpBB. Several popular websites, including Facebook, Flickr, MediaWiki, Twitter, and YouTube, also use MySQL.

History

The Swedish business MySQL AB, formed by Allan Larsson, Michael "Monty" Widenius, and David Axmark, was responsible for creating MySQL. Widenius and Axmark started working on MySQL's first development in 1994. The initial version of MySQL was launched on May 23, 1995. Since the low-level language ISAM was based on mSQL, it was first developed for personal use.

However, its developers felt that it was too sluggish and rigid. They retained the same mSQL API but constructed a new SQL interface. Many developers could switch from the (proprietarily licensed) mSQL predecessor to MySQL by maintaining the API compatible with the mSQL system.

  • MySQL is an open-source, multipurpose relational database management system developed by Michael Monty Widenius and David Axmark. Monty Widenius is primarily responsible for developing the bulk of the code. Monty's pronunciation of ess-que-ell is correct, but he doesn't mind if others say it differently. Several operating systems, including Windows, Mac OS, Linux, UNIX, and their variations, may be used with MySQL. It is written in both C and C++.
  • Midway through the 1990s, MySQL became well-known as an open-source alternative to mSQL, a small database system often utilized for personal use. An open-source license for mSQL could never be obtained, and its suitability as a website database must be fully established. Numerous applications might easily transition to MySQL due to the full API compatibility between mSQL and MySQL.
  • When MySQL was first released to the public in May 1995, it was provided under the GNU General Public License. The founders of MySQL formed MySQL AB to control and own the first version of the database management system. They planned to sell proprietary licenses and maintenance contracts while keeping the source utterly compliant with the GPL. With continued development throughout the late 1990s and early 2000s,
  • MySQL evolved into a feature-rich relational database management system with enterprise-level capabilities. Although there were rumours that MySQL AB was getting ready for an IPO in 2008, Sun Microsystems ultimately purchased them. At that point, MySQL was, without a doubt, the most popular database management system for websites and small- to medium-sized businesses. Sun kept the original team and let them continue running the company's MySQL business.
  • Oracle Corporation acquired Sun Microsystems in January 2010 due to Sun Microsystems' financial troubles spurred on by the decline in the microcomputer industry. Immediately upon establishing Maria Corporation AB, Monty Widenius used his development team.
  • Then, he gave his second daughter an open-source MySQL offshoot named MariaDB. Despite the misgivings of many, myself included, MySQL has thrived under Oracle's guidance. Despite having a negative reputation for opposing open-source software, Oracle has effectively maintained MySQL's business model, given the project access to its extensive database expertise, and assisted in its growth into a significant participant in the database market.
  • MySQL is as robust as any central database system, including foreign vital limitations, database partitioning clusters, complete acid compliance transactions, and many other state-of-the-art database features. As of this recording, MySQL version 8.0 is the most current version supported.
Version Name Released Date Description
MySQL 5.1 14-11-2008 The MySQL 5.0 to MySQL 5.1.73 releases are included in this version.
MySQL 5.5 03-12-2010 The MySQL 5.5 through MySQL 5.5.62 releases are included in this version.
MySQL 5.6 05-02-2013 The MySQL 5.6 through MySQL 5.5.45 releases are included in this version.
MySQL 5.7 21-10-2015 The MySQL 5.7 through MySQL 5.6.27 releases are included in this version.
MySQL 8.0 19-04-2018 The MySQL 8.0 through MySQL 8.0.21 releases are included in this version.

Conclusion

Wideners, Larsson, and Axmark, developed MySQL, a free and open-source database management system, in 1995. It began as an alternative to MySQL and prospered under the leadership of Sun Microsystems and then Oracle. Large websites and online applications still depend heavily on MySQL 8.0, the most current version, which is still essential in many development scenarios.