Podcast
Questions and Answers
What does MySQL stand for?
What does MySQL stand for?
Answer hidden
What is the role of SQL in MySQL?
What is the role of SQL in MySQL?
Answer hidden
Under which license is MySQL available?
Under which license is MySQL available?
Answer hidden
What was created by Widenius after Oracle acquired Sun Microsystems?
What was created by Widenius after Oracle acquired Sun Microsystems?
Answer hidden
Who sued MySQL AB, TcX DataKonsult AB, and its original authors in U.S District Court in Boston?
Who sued MySQL AB, TcX DataKonsult AB, and its original authors in U.S District Court in Boston?
Answer hidden
Which company acquired Innobase OY, the Finnish company that developed the third-party InnoDB storage engine?
Which company acquired Innobase OY, the Finnish company that developed the third-party InnoDB storage engine?
Answer hidden
Who bought MySQL AB for $1 billion in January 2008?
Who bought MySQL AB for $1 billion in January 2008?
Answer hidden
Who entered into an agreement to purchase Sun Microsystems, then owners of MySQL copyright and trademark, in April 2009?
Who entered into an agreement to purchase Sun Microsystems, then owners of MySQL copyright and trademark, in April 2009?
Answer hidden
Who pledged to continue to enhance MySQL after the acquisition of MySQL AB?
Who pledged to continue to enhance MySQL after the acquisition of MySQL AB?
Answer hidden
Who started the movement to 'Save MySQL' from Oracle after the acquisition of MySQL AB?
Who started the movement to 'Save MySQL' from Oracle after the acquisition of MySQL AB?
Answer hidden
Which company was sued by MySQL AB for copyright and trademark infringement in United States district court?
Which company was sued by MySQL AB for copyright and trademark infringement in United States district court?
Answer hidden
Which company acquired Sleepycat Software, makers of the Berkeley DB, in February 2006?
Which company acquired Sleepycat Software, makers of the Berkeley DB, in February 2006?
Answer hidden
When was the first version of MySQL created?
When was the first version of MySQL created?
Answer hidden
Which company initially created MySQL?
Which company initially created MySQL?
Answer hidden
What is the acronym LAMP used for?
What is the acronym LAMP used for?
Answer hidden
Which of the following is not a popular web application using MySQL?
Which of the following is not a popular web application using MySQL?
Answer hidden
Which languages are MySQL written in?
Which languages are MySQL written in?
Answer hidden
What are the system platforms MySQL works on?
What are the system platforms MySQL works on?
Answer hidden
Under which licenses are the MySQL server software and client libraries distributed?
Under which licenses are the MySQL server software and client libraries distributed?
Answer hidden
Where can free support for MySQL be obtained?
Where can free support for MySQL be obtained?
Answer hidden
When was MySQL 5.6 with new features announced?
When was MySQL 5.6 with new features announced?
Answer hidden
When was MySQL Server 8.0 announced?
When was MySQL Server 8.0 announced?
Answer hidden
Who acquired MySQL AB in 2008?
Who acquired MySQL AB in 2008?
Answer hidden
Which popular websites use MySQL?
Which popular websites use MySQL?
Answer hidden
Who originally created PHP?
Who originally created PHP?
Answer hidden
What does PHP stand for?
What does PHP stand for?
Answer hidden
How is PHP code usually processed on a web server?
How is PHP code usually processed on a web server?
Answer hidden
What powers the standard PHP interpreter?
What powers the standard PHP interpreter?
Answer hidden
What was the main aim of the PHP 7 development?
What was the main aim of the PHP 7 development?
Answer hidden
What major change was made to the syntax for variable dereferencing in PHP 7?
What major change was made to the syntax for variable dereferencing in PHP 7?
Answer hidden
What was the reason behind naming the new PHP version as PHP 7?
What was the reason behind naming the new PHP version as PHP 7?
Answer hidden
What was the main reason for giving the reworked Zend Engine the name Zend Engine 3?
What was the main reason for giving the reworked Zend Engine the name Zend Engine 3?
Answer hidden
What was the main advantage of the changes from phpng in terms of future performance improvements?
What was the main advantage of the changes from phpng in terms of future performance improvements?
Answer hidden
What major change was made to the behavior of the list() operator in PHP 7?
What major change was made to the behavior of the list() operator in PHP 7?
Answer hidden
What was the main reason for deprecating support for legacy PHP 4-style constructor methods in PHP 7?
What was the main reason for deprecating support for legacy PHP 4-style constructor methods in PHP 7?
Answer hidden
What was the main reason for changing the behavior of the foreach statement in PHP 7?
What was the main reason for changing the behavior of the foreach statement in PHP 7?
Answer hidden
When was PHP 4, powered by the Zend Engine 1.0, released?
When was PHP 4, powered by the Zend Engine 1.0, released?
Answer hidden
What percentage of PHP users use PHP 7.4?
What percentage of PHP users use PHP 7.4?
Answer hidden
Who rewrote the parser in 1997, forming the base of PHP 3?
Who rewrote the parser in 1997, forming the base of PHP 3?
Answer hidden
Which Linux distributions offer commercial support and paid security patches for PHP?
Which Linux distributions offer commercial support and paid security patches for PHP?
Answer hidden
In which year was PHP development initiated with Rasmus Lerdorf's CGI programs in C?
In which year was PHP development initiated with Rasmus Lerdorf's CGI programs in C?
Answer hidden
What was the early implementation of PHP used for?
What was the early implementation of PHP used for?
Answer hidden
When was PHP 5, powered by Zend Engine II, released?
When was PHP 5, powered by Zend Engine II, released?
Answer hidden
What percentage of PHP users use PHP 8.x versions?
What percentage of PHP users use PHP 8.x versions?
Answer hidden
What was PHP/FI released as in June 1995?
What was PHP/FI released as in June 1995?
Answer hidden
Who began PHP development with Rasmus Lerdorf's CGI programs in C?
Who began PHP development with Rasmus Lerdorf's CGI programs in C?
Answer hidden
Which version of PHP is vulnerable to hacking?
Which version of PHP is vulnerable to hacking?
Answer hidden
When was PHP syntax released?
When was PHP syntax released?
Answer hidden
Study Notes
MySQL Overview and History
- MySQL is a component of the LAMP web application software stack, acronym for Linux, Apache, MySQL, Perl/PHP/Python.
- It is used by many database-driven web applications, including Drupal, Joomla, phpBB, and WordPress.
- MySQL is also used by popular websites like Facebook, Flickr, MediaWiki, Twitter, and YouTube.
- It is written in C and C++ and works on various system platforms like Linux, macOS, Microsoft Windows, and others.
- The MySQL server software and client libraries use dual-licensing distribution under GPL version 2 or a proprietary license.
- Support can be obtained from the official manual, free support is available in different IRC channels and forums, and Oracle offers paid support via its MySQL Enterprise products.
- MySQL was created by a Swedish company, MySQL AB, and development began in 1994.
- The first version of MySQL appeared on 23 May 1995, initially created for personal usage from mSQL based on the low-level language ISAM.
- MySQL development milestones include significant releases like version 3.20 in January 1997, version 5.0 in October 2005, and version 5.1 in November 2008.
- Sun Microsystems acquired MySQL AB in 2008, and Oracle acquired Sun Microsystems in 2010.
- MySQL Server 5.5 was generally available in December 2010, and MySQL 5.6 with new features was announced in February 2013.
- MySQL 5.7 was announced in October 2015, and MySQL Server 8.0 was announced in April 2018, including new functions and improved sorting.
Evolution of PHP Language
- PHP does not have a formal standard; the original implementation acts as the de facto standard
- According to W3Techs, PHP is used by 76.6% of websites with known server-side programming languages
- 20.1% of PHP users use 8.x versions, 61.3% use PHP 7.4, and 18.3% use PHP 5, which is vulnerable to hacking
- Some Linux distributions like Ubuntu and Debian offer commercial support and paid security patches for PHP
- PHP development began in 1993 with Rasmus Lerdorf's CGI programs in C
- PHP/FI, the early implementation, was used for simple, dynamic web applications
- PHP/FI was released as "Personal Home Page Tools (PHP Tools) version 1.0" in June 1995
- PHP syntax resembled Perl but was simpler and less consistent
- Zeev Suraski and Andi Gutmans rewrote the parser in 1997, forming the base of PHP 3
- PHP 4, powered by the Zend Engine 1.0, was released on May 22, 2000
- PHP 5, powered by Zend Engine II, was released on July 1, 2004, with improved support for object-oriented programming
- PHP received mixed reviews due to lacking native Unicode support, leading to delays in the PHP 6 project and the eventual abandonment of the Unicode integration plan
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge of MySQL with this quiz covering its overview and history. Learn about its role in the LAMP stack, its usage by popular websites, development milestones, and licensing. See how much you know about this widely used database management system.