MySQL was created by a Swidish company, MySQL AB, which was founded in 1995. The company was later acquired by Sun Microsystems in the year 2008 for about $1 billion.
The project of MySQL began in the year 1979 in the form of UNIREG which was an in-house database tool developed to manage databases. UNIREG was created by Michael Widenius. Following the creation of UNIREG, it was rewritten in several different languages to make it capable to handle big databases.
MySQL, named after Michael Widenius’s daughter, “My”,was created by combining mSQL and UNIREG. Michael Widenius and David Hughes, who had created mSQL, collaborated to connect mSQL to UNIREG’s B+ ISAM handler in order to provide indexing in mSQL.
Development of MySQL over the years:
1995 | Michael Widenius, David Axmark and Allan Larsson founded MySQL AB in Sweden. |
2000 | MySQL releases under GPL (General Public License) and goes open source. This led to 80% drop in revenues, which took a year to recover. |
2001 | Marten Mickos, a sales and marketing person, was elected the CEO. |
2002 | User base of MySQL reaches above 3 million. Revenue of the year was around $6.5. US headquarters was also launched this year. |
2003 | 4 million active users with 30,000 downloads per day, revenue reaches $l2 million. |
2004 | MySQL moves into the enterprise market and shifts from one time licensing fees from OEM partners to recurring revenues from end users. Revenue reaches $20. |
2005 | MySQL network launched. MySQL 5 ships with many new features. Revenues around $34. |
2006 | Oracle tries to buy MySQL. MySQL has a 33% market share on install base in database market. |
2007 | Year ended with a revenue of $75 million. |
2008 | Sun Microsystem acquires MySQL AB for $1 billion. |
2009 | Oracle acquires Sun common stock for about $7.4 billion. |
MySQL tutorial
- Backbone.js trigger() Event
- Backbone.JS Extend() collection
- Backbone.JS FindWhere() collection
- Backbone.JS View $(jQuery)
- Backbone.JS View Template()
- History of MySQL
- MySQL advantages and disadvantages
- Data Types in MySQL
- Install MySQL
- Create Database in MySQL
- Select Database in MySQL
- Drop Database in MySQL
- CREATE TABLE in MySQL
- ALTER TABLE in MySQL
- TRUNCATE TABLE in MySQL
- DROP TABLE in MySQL
- VIEW in MySQL
- QUERIES in MySQL
- Insert query in MySQL
- UPDATE query in MySQL
- DELETE query in MySQL
- SELECT query in MySQL
- WHERE clause in MySQL
- DISTINCT in MySQL
- FROM clause in MySQL
- ORDER BY in MySQL
- GROUP BY in MySQL
- Having clause in MySQL
- Like clause in MySQL
- IN clause in MySQL
- NOT clause in MySQL
- IS NULL in MySQL
- IS NOT NULL in MySQL
- And condition in MySQL
- OR condition in MySQL
- AND OR in MySQL
- BETWEEN in MySQL
- JOINS in MySQL
- SUM function in MySQL
- COUNT function in MySQL
- AVG function in MySQL
- MIN function in MySQL
- MAX function in MySQL
- FIRST function in MySQL
- LAST function in MySQL
- MariaDB vs MySQL
- PostgreSQL vs MySQL
- ADDDATE() FUNCTION in MySQL
- DATE() FUNCTION in MySQL
- ADDTIME() FUNCTION in MySQL
- CURDATE() FUNCTION in MySQL
- DATE_ADD() FUNCTION in MySQL
- DATE_FORMAT() FUNCTION in MySQL
- DATEDIFF() FUNCTION in MySQL
- DAYNAME() FUNCTION in MySQL
- DAYOFMONTH() FUNCTION in MySQL
- DAYOFWEEK() function in MySQL
- DAYOFYEAR() function in MySQL
- FROM_DAYS() FUNCTION in MySQL
- DAY() FUNCTION in MySQL
- HOUR() FUNCTION in MySQL
- CURRENT_TIME() FUNCTION in MySQL
- CURTIME() FUNCTION in MySQL
- CURRENT_DATE() FUNCTION in MySQL
- CURRENT_TIMESTAMP() FUNCTION in MySQL
- LAST_DAY() FUNCTION in MySQL
- LOCALTIME() FUNCTION in MySQL
- CONCAT_WS function in MySQL
- CONCAT() FUNCTION in MySQL
- CHARACTER_LENGTH() FUNCTION in MySQL
- LENGTH() FUNCTION in MySQL
- FIELD() FUNCTION in MySQL
- FIND_IN_SET() FUNCTION in MySQL
- FORMAT() FUNCTION in MySQL
- INSERT() FUNCTION in MySQL
- INSTR() FUNCTION in MySQL
- LCASE() FUNCTION in MySQL
- LOWER() FUNCTION in MySQL
- LEFT() FUNCTION in MySQL
- RIGHT() FUNCTION in MySQL
- LOCATE() FUNCTION in MySQL
- POSITION() FUNCTION in MySQL
- LPAD() FUNCTION in MySQL
- RPAD() FUNCTION in MySQL
- LTRIM() FUNCTION in MySQL
- RTRIM() FUNCTION in MySQL
- MID() FUNCTION in MySQL
- SUBSTR() FUNCTION in MySQL
- SUBSTRING() FUNCTION in MySQL
- REPEAT() FUNCTION in MySQL
- REPLACE() FUNCTION in MySQL
- REVERSE() FUNCTION in MySQL
- SPACE() FUNCTION in MySQL
- STRCMP() FUNCTION in MySQL
- SUBSTRING_INDEX() FUNCTION in MySQL
- TRIM() FUNCTION in MySQL
- UCASE() FUNCTION in MySQL
- UPPER() FUNCTION in MySQL
- EXPORT_SET() FUNCTION in MySQL
- FROM_BASE64() FUNCTION in MySQL
- HEX() FUNCTION in MySQL
- ELT() FUNCTION in MySQL
- LIKE() FUNCTION in MySQL
- LOAD_FILE() FUNCTION in MySQL
- MAKE_SET() FUNCTION in MySQL
- OCTET_LENGTH() FUNCTION in MySQL
- OCT() FUNCTION in MySQL
- ORD() FUNCTION in MySQL
- QUOTE() FUNCTION in MySQL
- SOUNDEX() FUNCTION in MySQL
- UNHEX() FUNCTION in MySQL
- CREATE DATABASE in MySQL
- CREATE TABLE in MySQL
- Data Types in MySQL
- Kill Processes MySQL
- Get Size of Tables and Database in MySQL
- Get Record Count of Tables in MySQL
- Get All Tables in MySQL
- Get All Columns in MySQL
- Find All Tables in MySQL With Specific Column Names
- Concatenate Multiple Rows Into One Field MySQL
- Select Random Rows in MySQL
- Update From Another Table MySQL
- Alter Table if Column Not Exist in MySQL
- Select First Row In Each Group MySQL
- Insert into a table or update if exists MySQL
- Query results in CSV format MySQL
- Get list of User Accounts MySQL
- Get list of Procedures and Functions MySQL
- Get Duplicate Values MySQL